[cx-oracletools-users] exportObject unable to locate LOB segment
Brought to you by:
atuining
Menu
▾
▴
[cx-oracletools-users] exportObject unable to locate LOB segment
|
From: Meyer M. <Mat...@ge...> - 2012-09-19 12:56:23
|
Hello all, I get an error when using exportObject: "C:\Program Files\cx_OracleTools\ExportObjects.exe" --schema=myuser/mypass@myTNS --use-dba-views --include-view-columns --include-roles --include-users --include-contexts -t --default-storage After a while this error occurs: "Unable to locate LOB segment DWH.OTHER_XML" (see stacktracke below). There is no object called OTHER_XML in no schema of the database. It's just the CLOB column in the table, described with the sql below the stacktrace. I'm not really sure if this really a problem of oracletools or cx_oracle really, but any help or indications would be really appreciated. And I think, you guys know your way around both libs... I also saw the related post from 2007 (http://sourceforge.net/mailarchive/message.php?msg_id=209850) but I didn't want to raise any zombie threads referencing outdated versions... Also the solution there seems a little... hacky... Thanks in advance, Matthias Meyer Additional Information: The stacktrace is: Describing roles... Describing users... Describing contexts... Describing synonyms... Describing sequences... Describing tables... 13:20:53.143 Python exception encountered: 13:20:53.190 Message: Unable to locate LOB segment DWH.OTHER_XML 13:20:53.190 Template Id: 0 13:20:53.190 Arguments: 13:20:53.190 name => 'OTHER_XML' 13:20:53.190 owner => 'DWH' 13:20:53.190 Traceback: 13:20:53.190 file cx_OracleObject\Object.py, line 699, in __RetrieveSegment 13:20:53.190 file cx_OracleObject\Object.py, line 667, in __init__ 13:20:53.190 file cx_OracleObject\Object.py, line 1185, in ObjectIterator 13:20:53.190 file cx_OracleObject\Object.py, line 962, in __RetrieveColumns 13:20:53.190 file cx_OracleObject\Object.py, line 891, in __init__ 13:20:53.190 file cx_OracleObject\Object.py, line 1185, in ObjectIterator 13:20:53.190 file cx_OracleObject\Describer.py, line 170, in ExportObjects 13:20:53.190 file cx_OracleObject\Describer.py, line 219, in ExportTables 13:20:53.190 file cx_OracleObject\Describer.py, line 103, in ExportAllObjects 13:20:53.190 file ExportObjects.py, line 54, in <module> 13:20:53.190 file Console.py, line 27, in <module> 13:20:53.190 Details: 13:20:53.190 Local Variables: 13:20:53.190 file cx_OracleObject\Object.py, line 699, in __RetrieveSegment 13:20:53.190 cursor -> <cx_OracleEx.Cursor on <cx_OracleEx.Connection to DW...@DW...>> 13:20:53.190 isPrepared -> <cx_OracleEx.Cursor on <cx_OracleEx.Connection to DW...@DW...>> 13:20:53.190 row -> None 13:20:53.190 self -> <cx_OracleObject.Object.Lob object at 0x08130D10> 13:20:53.190 file cx_OracleObject\Object.py, line 667, in __init__ 13:20:53.190 environment -> <cx_OracleObject.Environment.Environment object at 0x00D2F290> 13:20:53.190 name -> 'OTHER_XML' 13:20:53.190 owner -> 'DWH' 13:20:53.190 row -> ('DWH', 'OTHER_XML', 'QUEST_SL_TEMP_EXPLAIN3', 'SYS_LOB0000175581C00027$$', 'YES') 13:20:53.190 self -> <cx_OracleObject.Object.Lob object at 0x08130D10> 13:20:53.190 file cx_OracleObject\Object.py, line 1185, in ObjectIterator 13:20:53.190 args -> () 13:20:53.190 classFactory -> <class 'cx_OracleObject.Object.Lob'> 13:20:53.190 cursor -> <cx_OracleEx.Cursor on <cx_OracleEx.Connection to DW...@DW...>> 13:20:53.190 environment -> <cx_OracleObject.Environment.Environment object at 0x00D2F290> 13:20:53.190 keywordArgs -> {'owner': 'DWH', 'name': 'QUEST_SL_TEMP_EXPLAIN3'} 13:20:53.190 row -> ('DWH', 'OTHER_XML', 'QUEST_SL_TEMP_EXPLAIN3', 'SYS_LOB0000175581C00027$$', 'YES') 13:20:53.190 statement -> '\n select\n o.owner,\n o.column_name,\n o.table_name,\n o.segment_name,\n o.in_row\n from %(p_ViewPrefix)s_lobs o\n %(p_WhereClause)s\n order by o.column_name' 13:20:53.190 tag -> 'Lobs' 13:20:53.190 whereClause -> 'where o.owner = :owner and o.table_name = :name' 13:20:53.190 file cx_OracleObject\Object.py, line 962, in __RetrieveColumns 13:20:53.190 c -> ('QBLOCK_NAME', 'VARCHAR2', 'Y', None, None, 120, None) 13:20:53.190 cursor -> <cx_OracleEx.Cursor on <cx_OracleEx.Connection to DW...@DW...>> 13:20:53.190 isPrepared -> <cx_OracleEx.Cursor on <cx_OracleEx.Connection to DW...@DW...>> 13:20:53.190 lobColumns -> ['OTHER_XML'] 13:20:53.190 self -> <cx_OracleObject.Object.Table object at 0x081182F0> 13:20:53.190 file cx_OracleObject\Object.py, line 891, in __init__ 13:20:53.190 duration -> 'SYS$SESSION' 13:20:53.190 environment -> <cx_OracleObject.Environment.Environment object at 0x00D2F290> 13:20:53.190 iotType -> None 13:20:53.190 name -> 'QUEST_SL_TEMP_EXPLAIN3' 13:20:53.190 owner -> 'DWH' 13:20:53.190 partitioned -> 'NO' 13:20:53.190 row -> ('DWH', 'QUEST_SL_TEMP_EXPLAIN3', None, None, None, None, None, None, 'Y', 'NO', 'SYS$SESSION', None) 13:20:53.190 self -> <cx_OracleObject.Object.Table object at 0x081182F0> 13:20:53.190 temporary -> 'Y' 13:20:53.190 file cx_OracleObject\Object.py, line 1185, in ObjectIterator 13:20:53.190 args -> () 13:20:53.190 classFactory -> <class 'cx_OracleObject.Object.Table'> 13:20:53.190 cursor -> <cx_OracleEx.Cursor on <cx_OracleEx.Connection to DW...@DW...>> 13:20:53.190 environment -> <cx_OracleObject.Environment.Environment object at 0x00D2F290> 13:20:53.190 keywordArgs -> {} 13:20:53.190 row -> ('DWH', 'QUEST_SL_TEMP_EXPLAIN3', None, None, None, None, None, None, 'Y', 'NO', 'SYS$SESSION', None) 13:20:53.190 statement -> "\n select\n o.owner,\n o.table_name,\n o.tablespace_name,\n o.initial_extent,\n o.next_extent,\n o.min_extents,\n o.max_extents,\n o.pct_increase,\n o.temporary,\n o.partitioned,\n o.duration,\n o.iot_type\n from %(p_ViewPrefix)s_tables o\n %(p_WhereClause)s\n and secondary = 'N'\n order by o.owner, o.table_name" 13:20:53.190 tag -> 'AllTables' 13:20:53.190 whereClause -> "where o.owner = 'DWH'" 13:20:53.190 file cx_OracleObject\Describer.py, line 170, in ExportObjects 13:20:53.190 obj -> <cx_OracleObject.Object.Table object at 0x08118CD0> 13:20:53.190 self -> <cx_OracleObject.Describer.Exporter object at 0x00D2F2D0> 13:20:53.190 sequence -> <generator object ObjectIterator at 0x00D33350> 13:20:53.190 file cx_OracleObject\Describer.py, line 219, in ExportTables 13:20:53.190 self -> <cx_OracleObject.Describer.Exporter object at 0x00D2F2D0> 13:20:53.190 file cx_OracleObject\Describer.py, line 103, in ExportAllObjects 13:20:53.190 self -> <cx_OracleObject.Describer.Exporter object at 0x00D2F2D0> 13:20:53.190 file ExportObjects.py, line 54, in <module> 13:20:53.190 Options -> <module 'Options' from 'C:\Program Files\cx_OracleTools\library.zip\Options.pyc'> 13:20:53.206 connection -> <cx_OracleEx.Connection to DW...@DW...> 13:20:53.206 cx_LoggingOptions -> <module 'cx_LoggingOptions' from 'C:\Program Files\cx_OracleTools\library.zip\cx_LoggingOptions.pyc'> 13:20:53.206 cx_OptionParser -> <module 'cx_OptionParser' from 'C:\Program Files\cx_OracleTools\library.zip\cx_OptionParser.pyc'> 13:20:53.206 cx_OracleObject -> <module 'cx_OracleObject' from 'C:\Program Files\cx_OracleTools\library.zip\cx_OracleObject\__init__.pyc'> 13:20:53.206 cx_OracleUtils -> <module 'cx_OracleUtils' from 'C:\Program Files\cx_OracleTools\library.zip\cx_OracleUtils.pyc'> 13:20:53.206 environment -> <cx_OracleObject.Environment.Environment object at 0x00D2F290> 13:20:53.206 exporter -> <cx_OracleObject.Describer.Exporter object at 0x00D2F2D0> 13:20:53.206 options -> <Values at 0xd33238: {'includeContexts': True, 'help': None, 'asOfScn': None, 'objectTypes': [], 'logLevel': 'error', 'wantStorage': False, 'baseDir': '.', 'useDbaViews': True, 'wantComments': True, 'wantGrants': True, 'schemas': [], 'wantTablespace': True, 'showBanner': None, 'wantQuotas': True, 'wantViewColumns': True, 'maxLongSize': 131072, 'version': None, 'splitRelated': False, 'mergeGrants': True, 'schema': 'DWH/don...@DW...', 'includeRoles': True, 'onlyIf': None, 'wantRelated': ... 13:20:53.206 parser -> <cx_OptionParser.OptionParser instance at 0x00D27F58> 13:20:53.206 file Console.py, line 27, in <module> 13:20:53.206 DIR_NAME -> 'C:\\Program Files\\cx_OracleTools' 13:20:53.206 EXCLUSIVE_ZIP_FILE_NAME -> 'C:\\Program Files\\cx_OracleTools\\ExportObjects.zip' 13:20:53.206 FILE_NAME -> 'C:\\Program Files\\cx_OracleTools\\ExportObjects.exe' 13:20:53.206 INITSCRIPT_ZIP_FILE_NAME -> 'C:\\Program Files\\cx_OracleTools\\library.zip' 13:20:53.206 SHARED_ZIP_FILE_NAME -> 'C:\\Program Files\\cx_OracleTools\\library.zip' 13:20:53.206 code -> <code object <module> at 00B59BA8, file "ExportObjects.py", line 6> 13:20:53.206 ext -> '.exe' 13:20:53.206 importer -> <zipimporter object "C:\Program Files\cx_OracleTools\library.zip"> 13:20:53.206 m -> <module '__main__' (built-in)> 13:20:53.206 moduleName -> 'exportobjects__main__' 13:20:53.206 name -> 'exportobjects' 13:20:53.206 os -> <module 'os' from '<frozen>'> 13:20:53.206 sys -> <module 'sys' (built-in)> 13:20:53.206 zipimport -> <module 'zipimport' (built-in)> The sql for the object in question is: CREATE GLOBAL TEMPORARY TABLE DWH.QUEST_SL_TEMP_EXPLAIN3 ( STATEMENT_ID VARCHAR2(30 CHAR), PLAN_ID NUMBER, TIMESTAMP DATE, REMARKS VARCHAR2(4000 CHAR), OPERATION VARCHAR2(30 CHAR), OPTIONS VARCHAR2(255 CHAR), OBJECT_NODE VARCHAR2(128 CHAR), OBJECT_OWNER VARCHAR2(30 CHAR), OBJECT_NAME VARCHAR2(30 CHAR), OBJECT_ALIAS VARCHAR2(65 CHAR), OBJECT_INSTANCE INTEGER, OBJECT_TYPE VARCHAR2(30 CHAR), OPTIMIZER VARCHAR2(255 CHAR), SEARCH_COLUMNS NUMBER, ID INTEGER, PARENT_ID INTEGER, DEPTH INTEGER, POSITION INTEGER, COST INTEGER, CARDINALITY INTEGER, BYTES INTEGER, OTHER_TAG VARCHAR2(255 CHAR), PARTITION_START VARCHAR2(255 CHAR), PARTITION_STOP VARCHAR2(255 CHAR), PARTITION_ID INTEGER, OTHER LONG, OTHER_XML CLOB, DISTRIBUTION VARCHAR2(30 CHAR), CPU_COST INTEGER, IO_COST INTEGER, TEMP_SPACE INTEGER, ACCESS_PREDICATES VARCHAR2(4000 CHAR), FILTER_PREDICATES VARCHAR2(4000 CHAR), PROJECTION VARCHAR2(4000 CHAR), TIME NUMBER(20,2), QBLOCK_NAME VARCHAR2(30 CHAR) ) ON COMMIT PRESERVE ROWS RESULT_CACHE (MODE DEFAULT) NOCACHE; GRANT SELECT ON DWH.QUEST_SL_TEMP_EXPLAIN3 TO GEHE_ORGA_READ_ONLY; Additional debug information: Version is: ExportObjects 8.0 (September 09, 2010 16:52:33) Build: September 09, 2010 16:53:23 on yeg5gjdjh1 Running on Windows XP SP3 and python 2.7.3 Database Version is: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0 Production TNS for IBM/AIX RISC System/6000: Version 11.2.0.2.0 - Production NLSRTL Version 11.2.0.2.0 - Production GEHE Informatik Services GmbH & Co. KG, Stuttgart, AG Stuttgart HRA 12167 Neckartalstr. 155, D-70376 Stuttgart Geschäftsführer: Rainer Baumgärtner, Till Rausch, Erwin Schiller persönlich haftende Gesellschafterin: GEHE Informatik Services-Verwaltungs GmbH, Stuttgart, AG Stuttgart 15843 Weiterer Gesellschafter: GEHE Pharma Handel GmbH, Stuttgart, AG Stuttgart HRB 14591 USt-IdNr.: DE 811 655 252 ______________________________________________________________________ This email has been scanned by the Symantec Email Security.cloud service. For more information please visit http://www.symanteccloud.com ______________________________________________________________________ |
