[cx-oracletools-users] Weird ExportObjects error..
Brought to you by:
atuining
|
From: Michael M. <mm...@gm...> - 2007-09-27 20:55:12
|
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
|