[cx-oracletools-users] Weird ExportObjects error..

[Michael M. <mm...@gm...>]

python ExportObjects.py -t --log-level=debug
--log-file=/tmp/rebuildTableCHCO.log --schema=USER/PA...@TE...
--name=SCHEMA_NAME

=== snip ===
from user_segments
where segment_type = 'LOBSEGMENT' and segment_name = :p_SegmentName
14:14:28.704 BIND VARIABLES
   p_SegmentName => 'SYS_LOB0000084624C00005$$'
/usr/lib/python2.5/site-packages/cx_OracleObject/Object.py:548:
DeprecationWarning: raising a string exception is deprecated
 raise "Unable to locate LOB segment %s" % self.name
14:14:28.780 Configured Python exception encountered:
14:14:28.781     Message: Unable to locate LOB segment CLNT_DRUG_GRP_RULE
14:14:28.781     Template Id: 0
14:14:28.781     Arguments:
14:14:28.781     Traceback:
14:14:28.781         file
/usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 548,
in __RetrieveSegment
14:14:28.781         file
/usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 516,
in __init__
14:14:28.781         file
/usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 993,
in ObjectIterator
14:14:28.781     Details:
14:14:28.781         Exception type: Unable to locate LOB segment
CLNT_DRUG_GRP_RULE
14:14:28.781         Local Variables:
14:14:28.781         file
/usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 548,
in __RetrieveSegment
14:14:28.781           cursor -> <cx_OracleEx.Cursor on
<cx_OracleEx.Connection to ODS...@WK...>>
14:14:28.781           isPrepared -> None
14:14:28.781           row -> None
14:14:28.781           self -> <cx_OracleObject.Object.Lob object at 0x829aa2c>
14:14:28.781           statement -> "\n                    select\n
                 tablespace_name,\n
initial_extent,\n                      next_extent,\n
   min_extents,\n                      max_extents,\n
    pct_increase\nfrom user_segments\nwhere segment_type =
'LOBSEGMENT' and segment_name = :p_SegmentName"
14:14:28.781         file
/usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 516,
in __init__
14:14:28.781           environment ->
<cx_OracleObject.Environment.Environment object at 0x829244c>
14:14:28.781           name -> 'CLNT_DRUG_GRP_RULE'
14:14:28.781           owner -> 'ODS_CHCO'
14:14:28.781           row -> ('ODS_CHCO', 'CLNT_DRUG_GRP_RULE',
'CLIENT_DRUG_CLS_GRP', 'SYS_LOB0000084624C00005$$', 'YES')
14:14:28.781           self -> <cx_OracleObject.Object.Lob object at 0x829aa2c>
14:14:28.781         file
/usr/lib/python2.5/site-packages/cx_OracleObject/Object.py, line 993,
in ObjectIterator
14:14:28.781           args -> ()
14:14:28.781           classFactory -> <class 'cx_OracleObject.Object.Lob'>
14:14:28.781           cursor -> <cx_OracleEx.Cursor on
<cx_OracleEx.Connection to ODS...@WK...>>
14:14:28.781           environment ->
<cx_OracleObject.Environment.Environment object at 0x829244c>
14:14:28.781           keywordArgs -> {'p_Owner': 'ODS_CHCO',
'p_Name': 'CLIENT_DRUG_CLS_GRP'}
14:14:28.781           row -> ('ODS_CHCO', 'CLNT_DRUG_GRP_RULE',
'CLIENT_DRUG_CLS_GRP', 'SYS_LOB0000084624C00005$$', 'YES')
14:14:28.781           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'
14:14:28.781           tag -> 'Lobs'
14:14:28.781           whereClause -> 'where o.owner = :p_Owner and
o.table_name = :p_Name'
14:14:28.782 ending logging

-- 
<admiral>

Michael F. March ----- mmarch at gmail dot com

          "Seriously" - HSR