Re: [cx-oracletools-users] Weird ExportObjects error..
Brought to you by:
atuining
Menu
▾
▴
Re: [cx-oracletools-users] Weird ExportObjects error..
|
From: Anthony T. <ant...@gm...> - 2007-10-01 21:15:14
|
Interesting. Do you have the create table statement you used for this?
I wouldn't mind solving this problem but I've never seen it before.
I'd like to also eliminate the string exceptions at the same time.
Thanks.
On 9/27/07, Michael March <mm...@gm...> wrote:
> 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
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> cx-oracletools-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracletools-users
>
|