cx-oracletools-users Mailing List for cx_OracleTools
Brought to you by:
atuining
You can subscribe to this list here.
2003 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(3) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2004 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2006 |
Jan
(1) |
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
(2) |
Nov
|
Dec
|
2007 |
Jan
|
Feb
|
Mar
|
Apr
(3) |
May
(1) |
Jun
|
Jul
|
Aug
(5) |
Sep
(7) |
Oct
(1) |
Nov
|
Dec
|
2008 |
Jan
|
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2009 |
Jan
|
Feb
|
Mar
(3) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2010 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
2011 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(4) |
Dec
|
2012 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Mark H. <mh...@pi...> - 2015-07-09 21:08:34
|
Anybody seen this? using oracle 11, most recent download of cx_OracleTools. many TIA, Mark. DescribeSchema --schema=mh/foo ... create table a_h ( x number, y varchar2(10), "zztop" date, h_tmstamp timestamp(6), h_scn number, h_username varchar2(16), h_changetype varchar2(1), h_osuser varchar2(16), h_machine varchar2(16) 13:30:55.681 TypeError: %d format: a number is required, not NoneType ohm ~$ ExportObjects --schema=mh/foo Describing synonyms... Describing sequences... Describing tables... 13:31:37.107 TypeError: %d format: a number is required, not NoneType |
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 DWH@DWHT.WORLD>> 13:20:53.190 isPrepared -> <cx_OracleEx.Cursor on <cx_OracleEx.Connection to DWH@DWHT.WORLD>> 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 DWH@DWHT.WORLD>> 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 DWH@DWHT.WORLD>> 13:20:53.190 isPrepared -> <cx_OracleEx.Cursor on <cx_OracleEx.Connection to DWH@DWHT.WORLD>> 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 DWH@DWHT.WORLD>> 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 DWH@DWHT.WORLD> 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/donotsay@DWHT.WORLD', '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 ______________________________________________________________________ |
From: Victor H. <vic...@ya...> - 2011-11-09 00:08:48
|
heya, I'm attempting to use CopyData.py from another Python script. However, it's not proving the most amenable to being called - there aren't any classes, or functions I can plug into directly. At the moment, I'm just using subprocess to call the Python interpreter directly on CopyData.py - however, it'd obviously be much nicer if I could call it from within Python. Are there any other ways we might be able to leverage on CopyData.py from within Python? Or how hard would it be to wrap it up so it was a bit easier to work this way? Cheers, Victor |
From: Victor H. <vic...@ya...> - 2011-11-09 00:06:47
|
heya, Aweesome =). Yup, --no-check-exists works fine for us, although I thin I'll probably use the --key-columns (since there is a column we are "using" for PK, just not enforced...hmm). Cheers, Victor On Wed, Nov 9, 2011 at 02:59, Anthony Tuininga <ant...@gm...>wrote: > Yes, you can do it still. These are your options: > > (1) use the --no-check-exists option which will simply perform inserts > without checking to see if the row exists and an update is needed > (2) use the --key-columns option which specifies which columns > function as the key that identifies each row uniquely > > Hope that helps! > > Anthony > > On Mon, Nov 7, 2011 at 3:57 PM, Victor Hooi <vic...@ya...> wrote: > > Hi, > > I'm attempiting to use cx_OracleTool's CopyData.py script to copy data > > between two tables on separate Oracle schemas/instances. > > I get the error: > >> > >> No primary or unique constraint found on table. > > > > I don't know much about Oracle, to be honest, but from what I can tell > the > > tables don't seem to have any PK constraint or anything like that > defined. > > The merits of this aside, I think it's simply been setup that way for > > expediency, and it's unlikely to change anytime nearterm. > > Is there any way to get copyData.py to run in this scenario without a PK > > constraint? > > Cheers, > > Victor > > > ------------------------------------------------------------------------------ > > RSA(R) Conference 2012 > > Save $700 by Nov 18 > > Register now > > http://p.sf.net/sfu/rsa-sfdev2dev1 > > _______________________________________________ > > cx-oracletools-users mailing list > > cx-...@li... > > https://lists.sourceforge.net/lists/listinfo/cx-oracletools-users > > > > > |
From: Victor H. <vic...@ya...> - 2011-11-07 22:58:12
|
Hi, I'm attempiting to use cx_OracleTool's CopyData.py script to copy data between two tables on separate Oracle schemas/instances. I get the error: No primary or unique constraint found on table. I don't know much about Oracle, to be honest, but from what I can tell the tables don't seem to have any PK constraint or anything like that defined. The merits of this aside, I think it's simply been setup that way for expediency, and it's unlikely to change anytime nearterm. Is there any way to get copyData.py to run in this scenario without a PK constraint? Cheers, Victor |
From: Victor H. <vic...@ya...> - 2011-11-03 02:02:41
|
Hi, I'm looking at using cx_OracleTool's copyData script to synchronise the tables between two separate Oracle schemas. Firstly, I noticed in the cx_OracleTools README that it lists cx_PyGenLib, cx_PyOracleLib and cx_Oracle as it's requirements. However, in the CopyData.py script, it has the following imports: - import cx_Logging - import cx_LoggingOptions - import cx_OptionParser (from PyGenLib) - import cx_OracleUtils (from PyOracleLib) - import os The two Logging modules - they come from the cx_Logging project ( http://cx-logging.sourceforge.net/), right? Should they be added to the requirements in the README file? Second question - I have a source table and a destination table. I need to DELETE the rows from the destination table, then run the COPY. Is it possible to wrap these two operations in a transaction, whilst using the copyData.py script? Basically, we want to be able to rollback the DELETE if something goes wrong with the COPY? Cheers, Victor |
From: Anthony T. <ant...@gm...> - 2010-09-10 04:37:52
|
What is cx_OracleTools? cx_OracleTools is a set of Python scripts that handle Oracle database development tasks in a cross platform manner and improve (in my opinion) on the tools that are available by default in an Oracle client installation. Those who use cx_Oracle may also be interested in this project, if only as sample code. Binaries for Windows and Linux are provided for those who do not have a Python installation. Where do I get it? http://cx-oracletools.sourceforge.net What's new? 1) In DescribeObject, added option --show-synonyms which enables display of synonyms that reference the object. The default value for this option is false. 2) In DescribeObject, DescribeSchema, ExportObjects and RebuildTable, added support for Oracle context objects. 3) In DescribeSchema, ExportObjects and RecompileSource, added option --name-file which acts in the same fashion as the --name option except that the value of the option refers to a file containing a list of names, one name per line. 4) In DescribeObject, DescribeSchema and ExportObjects, added option --include-view-columns which enables specification of the column names when creating a view. 5) In DescribeObject and DescribeSchema added support for eliminating the quotas on tablespaces when generating create user statements. 6) In DescribeObject, DescribeSchema and ExportObjects, added options --as-of-timestamp and --as-of-scn which enable flashback queries when performing describes. This can be very useful for recovering those accidentally issued DDL commands! 7) In DumpCSV, make use of the builtin module csv and the standard option --schema; in addition, allow the file name to be specified as "-" or not at all in which case the output goes to stdout. 8) In DumpData, added support for dumping CLOB, BLOB and binary data values correctly. A commit statement is also appended to the output now as a convenience. 9) In ExportXML, added option --sort-by which allows the result set to be sorted before exporting. In addition, the source can be a query instead of simply a table name. 10) In GeneratePatch, switch to the new more intelligent parser. 11) In ImportXML, now use cElementTree rather than home-grown XML processing library. 12) In RebuildTable, removed SQL*Plus specific statements since by default connect statements are issued which only works properly with PatchDB. 13) In RecompileSource, added option --connect-as-owner and removed option --password. The new option specifies that when invalid objects are recompiled that a connection to the owner of the invalid object is established using the password of the current connection. The default value is false since this is an uncommon situation and is retained at all for support of product development at Computronix. 14) Replaced CompileSource with PatchDB which uses a much more advanced parser and is setup to handle additional commands besides executing SQL scripts. 15) Added setup.py for building with cx_Freeze which means that MSI packages for Windows and RPM packages for Linux are now available. 16) Other changes required to keep up with changes in Python, dependent libraries and Oracle (including up to Oracle 11.2) Anthony Tuininga |
From: Marcos O. V. <ml...@es...> - 2009-03-09 02:16:32
|
Thanks for your answer my friend. Very soon , you´ll have news of my person about my work with cx_Oracle regards El sáb, 07-03-2009 a las 12:04 +0000, cx-...@li... escribió: > Send cx-oracletools-users mailing list submissions to > cx-...@li... > > To subscribe or unsubscribe via the World Wide Web, visit > https://lists.sourceforge.net/lists/listinfo/cx-oracletools-users > or, via email, send a message with subject or body 'help' to > cx-...@li... > > You can reach the person managing the list at > cx-...@li... > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of cx-oracletools-users digest..." > > > Today's Topics: > > 1. Re: Regards to all members (Anthony Tuininga) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 6 Mar 2009 10:48:26 -0700 > From: Anthony Tuininga <ant...@gm...> > Subject: Re: [cx-oracletools-users] Regards to all members > To: cx-...@li... > Message-ID: > <703...@ma...> > Content-Type: text/plain; charset=ISO-8859-1 > > On Thu, Mar 5, 2009 at 7:05 PM, Marcos Ortiz Valmaseda > <ml...@es...> wrote: > > Firstly, regards to all members of the list. > > I write to you because I?m developing a Python aplication to be efective a > > Oracle migration to PostgreSQL compatible schema and I?m using many tools > > developed by Anthony Tuininga, especificaly cx_Oracle 5.0 and cx_OracleTools > > and I need to know what is the result of the DumpData.py module and the > > ExportData.py. > > ExportData will dump the data into a pickle type format that another > Python program could read but is designed for use by the paired tool > called ImportData. If you are interested in using it for your own > purposes then read the source code and ask me questions if you run > stuck. However if you're converting your own data you could simply > write your own code using cx_Oracle with the source of cx_OracleTools > as a guide if that's helpful. cx_OracleTools is meant to be generic, > though, so it may not help you as much as you might like. > > DumpData will dump the data as SQL statements that could be executed > by SQL*Plus, for example. Its intended for tables that contain a small > number of rows where someone might wish to > > > My aplication use the Python language on the core of the same and one > > version is developed with Qt4 and the second with Python module > > python-newt,excellent for to the development work with text-mode > > aplications. > > > > 2-? I need more examples of the cx_OracleTools use > > Using these at the command line? Or something else? All of the tools > have the --help option which will give you details on all of the > arguments and options and a description of each. > > > 3-? When you build a Connection Object with the cx_Oracle module, the sintax > > is very easy, but you can pass many options to the constructor. ?Which > > options I can pass? and please send a example. > > Most of the options are only needed for specialty situations. The > simplest is the following: > > connection = cx_Oracle.Connection("user/password@tnsentry") > > In other words, the same connect string format used by SQL*Plus. If > you want more details on the other options, look at the supplied > documentation for cx_Oracle. > > Anthony > > > > ------------------------------ > > ------------------------------------------------------------------------------ > Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA > -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise > -Strategies to boost innovation and cut costs with open source participation > -Receive a $600 discount off the registration fee with the source code: SFAD > http://p.sf.net/sfu/XcvMzF8H > > ------------------------------ > > _______________________________________________ > cx-oracletools-users mailing list > cx-...@li... > https://lists.sourceforge.net/lists/listinfo/cx-oracletools-users > > > End of cx-oracletools-users Digest, Vol 11, Issue 2 > *************************************************** |
From: Anthony T. <ant...@gm...> - 2009-03-06 17:49:10
|
On Thu, Mar 5, 2009 at 7:05 PM, Marcos Ortiz Valmaseda <ml...@es...> wrote: > Firstly, regards to all members of the list. > I write to you because I´m developing a Python aplication to be efective a > Oracle migration to PostgreSQL compatible schema and I´m using many tools > developed by Anthony Tuininga, especificaly cx_Oracle 5.0 and cx_OracleTools > and I need to know what is the result of the DumpData.py module and the > ExportData.py. ExportData will dump the data into a pickle type format that another Python program could read but is designed for use by the paired tool called ImportData. If you are interested in using it for your own purposes then read the source code and ask me questions if you run stuck. However if you're converting your own data you could simply write your own code using cx_Oracle with the source of cx_OracleTools as a guide if that's helpful. cx_OracleTools is meant to be generic, though, so it may not help you as much as you might like. DumpData will dump the data as SQL statements that could be executed by SQL*Plus, for example. Its intended for tables that contain a small number of rows where someone might wish to > My aplication use the Python language on the core of the same and one > version is developed with Qt4 and the second with Python module > python-newt,excellent for to the development work with text-mode > aplications. > > 2- I need more examples of the cx_OracleTools use Using these at the command line? Or something else? All of the tools have the --help option which will give you details on all of the arguments and options and a description of each. > 3- When you build a Connection Object with the cx_Oracle module, the sintax > is very easy, but you can pass many options to the constructor. ¿Which > options I can pass? and please send a example. Most of the options are only needed for specialty situations. The simplest is the following: connection = cx_Oracle.Connection("user/password@tnsentry") In other words, the same connect string format used by SQL*Plus. If you want more details on the other options, look at the supplied documentation for cx_Oracle. Anthony |
From: Marcos O. V. <ml...@es...> - 2009-03-05 22:59:23
|
Firstly, regards to all members of the list. I write to you because I´m developing a Python aplication to be efective a Oracle migration to PostgreSQL compatible schema and I´m using many tools developed by Anthony Tuininga, especificaly cx_Oracle 5.0 and cx_OracleTools and I need to know what is the result of the DumpData.py module and the ExportData.py. My aplication use the Python language on the core of the same and one version is developed with Qt4 and the second with Python module python-newt,excellent for to the development work with text-mode aplications. 2- I need more examples of the cx_OracleTools use 3- When you build a Connection Object with the cx_Oracle module, the sintax is very easy, but you can pass many options to the constructor. ¿Which options I can pass? and please send a example. Regards and thanks a lot. -- ¨¨Tip 9 : Vacumm es tu amigo.......¨¨¨ Marcos Ortíz Valmaseda Linux User # 418229 PostgreSQL 8.3.5 && Debian GNU/Linux Experimental User Facebook Profile: http://www.facebook.com/profile.php?id=1186800712 My blog: http://marcosluis21.wordpress.com |
From: Marius K. <am...@gm...> - 2008-06-11 08:11:34
|
hi, I was surprised to see that there were no ImportObjects.py script, so I went ahead and made one, which you can please add to cx-oracletools, and distribute with cx-oracletools in future. regards Marius Kruger -- bazaar-vcs.org Because I don't trust Version Control Systems with less than 10255 unit tests. |
From: Anthony T. <ant...@gm...> - 2008-03-31 19:28:26
|
Hi everyone, I thought I should let everyone know that I will be out of the country for about a month starting April 9. My wife and I are adopting two children from Africa and the vagaries of international adoption make it very difficult to know our exact return date. Internet access is also very sketchy in Africa. I will attempt to catch up when I return. :-) Anthony |
From: Anthony T. <ant...@gm...> - 2008-03-03 16:18:43
|
Hmm, that is quite strange. I'm not sure why the earlier code would have caused it to never complete but the newer code you suggested is better in any case. It works in Python 2.2 and higher and I have absolutely no interest in anything earlier than that anyway. :-) I've applied your patch to the Subversion repository. Thanks. Anthony On Mon, Mar 3, 2008 at 8:40 AM, Hancock, David (DHANCOCK) <DHA...@ar...> wrote: > > I found an earlier message about a problem dumping BLOBs and CLOBs, too > (September 2007). We just started encountering an issue, also, but our > symptom was just that the job never finished, so we found old processes from > many days ago still connected when we tried to shut down our database. (When > we run the job in the foreground, we get an error message about having > already fetched the LOB.) > > My coworker identified a fix. The extent of our testing has been to > demonstrate the problem, make this patch, and then run the same job and > watch it run to completion. Here's the diff for DumpCSV.py: > > --- DumpCSV.py.dist 2008-03-03 14:14:14.000000000 +0000 > +++ DumpCSV.py 2008-03-03 15:03:51.000000000 +0000 > @@ -65,12 +65,8 @@ > gRecordSeparator = EvalString(options.recordSep) > gStringEncloser = EvalString(options.stringEncloser) > gEscapeCharacter = EvalString(options.escapeChar) > -while True: > > - # fetch a single row > - row = cursor.fetchone() > - if not row: > - break > +for row in cursor: > > # dump the row > outFile.write(gFieldSeparator.join([StringRep(v) for v in row])) > > We are using Python 2.4, and it's likely that the "while True" idiom (and > the roll-your-own CSV output) is to allow DumpCSV.py to run on older Python > versions. > > Please copy my email on responses (if any). I'm not subscribed to the tools > list, just the main cx_Oracle list > > Cheers! > -- > David Hancock | dha...@ar... > |
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/PASS@TEST.NET > --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_USER@WKHTEST.TRAN.NET>> > 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_USER@WKHTEST.TRAN.NET>> > 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 > |
From: Michael M. <mm...@gm...> - 2007-09-28 00:25:38
|
546,549c546,547 < row = cursor.fetchone() < # total hack < if not row: < row = ['',0,0,0,0,0] --- > if not row: > raise "Unable to locate LOB segment %s" % self.name On 9/27/07, Michael March <mm...@gm...> wrote: > Just for kicks I created this VERY hacky hack.. It seems to silence > the issue.. but I'm not sure at what cost. > > On 9/27/07, Michael March <mm...@gm...> wrote: > > python ExportObjects.py -t --log-level=debug > > --log-file=/tmp/rebuildTableCHCO.log --schema=USER/PASS@TEST.NET > > --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_USER@WKHTEST.TRAN.NET>> > > 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_USER@WKHTEST.TRAN.NET>> > > 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 > >did > > "Seriously" - HSR > > > |
From: Michael M. <mm...@gm...> - 2007-09-28 00:25:19
|
Just for kicks I created this VERY hacky hack.. It seems to silence the issue.. but I'm not sure at what cost. On 9/27/07, Michael March <mm...@gm...> wrote: > python ExportObjects.py -t --log-level=debug > --log-file=/tmp/rebuildTableCHCO.log --schema=USER/PASS@TEST.NET > --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_USER@WKHTEST.TRAN.NET>> > 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_USER@WKHTEST.TRAN.NET>> > 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 > |
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/PASS@TEST.NET --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_USER@WKHTEST.TRAN.NET>> 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_USER@WKHTEST.TRAN.NET>> 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 |
From: Michael M. <mm...@gm...> - 2007-09-15 00:32:32
|
First off, things are going MUCH better with this whole tool set.. once I got my head out of my keister.. :) Anyway, can DataDump.py capture columns (and rows) with CLOBs and BLOBs types? When we attempt the 'dump' this error pops up in the log: (05:27:03 PM) ke...@tr...: 17:49:29.603 Details: 17:49:29.603 Exception type: Cannot convert <cx_Oracle.LOB object at 0xb7d5c968> to an Oracle constant representation. 17:49:29.603 Local Variables: 17:49:29.603 file /usr/lib/python2.5/site-packages/cx_OracleUtils.py, line 85, in GetConstantRepr 17:49:29.603 value -> <cx_Oracle.LOB object at 0xb7d5c968> 17:49:29.603 file DumpData.py, line 48, in <module> 17:49:29.603 connection -> <cx_OracleEx.Connection to USER@HOST> 17:49:29.603 cursor -> <cx_OracleEx.Cursor on <cx_OracleEx.Connection to USER@HOST>> 17:49:29.603 cx_LoggingOptions -> <module 'cx_LoggingOptions' from '/usr/lib/python2.5/site-packages/cx_LoggingOptions.pyc'> 17:49:29.603 cx_OptionParser -> <module 'cx_OptionParser' from '/usr/lib/python2.5/site-packages/cx_OptionParser.pyc'> 17:49:29.603 cx_OracleUtils -> <module 'cx_OracleUtils' from '/usr/lib/python2.5/site-packages/cx_OracleUtils.pyc'> 17:49:29.603 datetime -> <module 'datetime' from '/usr/lib/python2.5/lib-dynload/datetime.so'> 17:49:29.603 description -> [('RULE_NAM', <type 'cx_Oracle.STRING'>, 40, 40, 0, 0, 0), ('RULE_TXT', <type 'cx_Oracle.CLOB'>, -1, 4000, 0, 0, 1), ('COMPILED_RULE', <type 'cx_Oracle.BLOB'>, -1, 4000, 0, 0, 1), ('COMPILED_RULE_TYP_CDE_KEY', <type 'cx_Oracle.NUMBER'>, 17, 22, 16, 0, 1), ('DATA_CREATOR_NAM', <type 'cx_Oracle.STRING'>, 20, 20, 0, 0, 0), ('DATA_CREATED_TSTMP', <type 'datetime.datetime'>, 23, 7, 0, 0, 0), ('DATA_MODIFIER_NAM', <type 'cx_Oracle.STRING'>, 20, 20, 0, 0, 0), ('DATA_MODIFIED_TSTMP', <type 'datetime.... 17:49:29.603 format -> 'insert into %s (\n %s\n) values (\n %s\n);\n' 17:49:29.603 i -> 1 17:49:29.603 names -> ['RULE_NAM', 'RULE_TXT'] 17:49:29.603 options -> <Values at 0xb6b8ae8c: {'showBanner': None, 'help': None, 'logLevel': 'debug', 'sourceQuery': None, 'traceback': None, 'tableName': 'ODS_DTS.XML_EXPRESSION', 'version': None, 'sortBy': None, 'logPrefix': '%t', 'logFile': '/tmp/DumpDataLog4.txt', 'schema': 'USER@HOST'}> 17:49:29.603 os -> <module 'os' from '/usr/lib/python2.5/os.pyc'> 17:49:29.603 parser -> <cx_OptionParser.OptionParser instance at 0xb6b8abec> 17:49:29.603 query -> 'select * from ODS_DTS.XML_EXPRESSION' 17:49:29.603 row -> ('1_TXRULE', <cx_Oracle.LOB object at 0xb7d5c968>, <cx_Oracle.LOB object at 0xb7d5c980>, 293, 'ip601', datetime.datetime(2007, 6, 27, 0, 0), 'ip601', datetime.datetime(2007, 6, 27, 17, 50, 24), datetime.datetime(2007, 6, 27, 0, 0))17:49:29.603 sequence -> [0, 1, 2, 3, 4, 5, 6, 7, 8] 17:49:29.603 sys -> <module 'sys' (built-in)> 17:49:29.603 value -> <cx_Oracle.LOB object at 0xb7d5c968> 17:49:29.603 values -> ["'1_TXRULE'"] -- <admiral> Michael F. March ----- mmarch at gmail dot com "Seriously" - HSR |
From: Michael M. <mm...@gm...> - 2007-09-13 15:26:48
|
You are right.. I had the 2.3 version installed somehow.. I have no idea how I did that because this is a 'fresh' install... but you were right. However, I installed the 2.4 versions and I am still getting the same error.. Do I have to do anything special to get rid of the 2.3 version? On 9/13/07, Anthony Tuininga <ant...@gm...> wrote: > > It looks like you have an older version of cx_PyOracleLib (and > cx_PyGenLib) which you will need to update. You can get that from > > http://cx-pyoraclelib.sourceforge.net > http://cx-pygenlib.sourceforge.net > > If that doesn't work for you, let me know. Thanks. > > Anthony > > On 9/12/07, Michael March <mm...@gm...> wrote: > > DumpData.py -t --log-level=debug --log-file=/tmp/log.txt > > --schema=USER/PASS@HOST TABLE_NAME > > Traceback (most recent call last): > > File "DumpData.py", line 44, in <module> > > if description[i][1] == connection.DATETIME \ > > AttributeError: 'cx_Oracle.Connection' object has no attribute > 'DATETIME' > > > > Here are the stats on the client side: > > Ubuntu 7.04 > > Oracle Express 10g > > Python 2.5.1 > > Latest cx_ toolset. > > > > Server side: > > Normal 10g > > > > -- > > <admiral> > > > > Michael F. March ----- mmarch at gmail dot com > > > > "Seriously" - HSR > > > |
From: Anthony T. <ant...@gm...> - 2007-09-13 14:16:14
|
It looks like you have an older version of cx_PyOracleLib (and cx_PyGenLib) which you will need to update. You can get that from http://cx-pyoraclelib.sourceforge.net http://cx-pygenlib.sourceforge.net If that doesn't work for you, let me know. Thanks. Anthony On 9/12/07, Michael March <mm...@gm...> wrote: > DumpData.py -t --log-level=debug --log-file=/tmp/log.txt > --schema=USER/PASS@HOST TABLE_NAME > Traceback (most recent call last): > File "DumpData.py", line 44, in <module> > if description[i][1] == connection.DATETIME \ > AttributeError: 'cx_Oracle.Connection' object has no attribute 'DATETIME' > > Here are the stats on the client side: > Ubuntu 7.04 > Oracle Express 10g > Python 2.5.1 > Latest cx_ toolset. > > Server side: > Normal 10g > > -- > <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 > > |
From: Michael M. <mm...@gm...> - 2007-09-12 20:33:51
|
<cx-...@li...>DumpData.py -t --log-level=debug --log-file=/tmp/log.txt --schema=USER/PASS@HOST TABLE_NAME Traceback (most recent call last): File "DumpData.py", line 44, in <module> if description[i][1] == connection.DATETIME \ AttributeError: 'cx_Oracle.Connection' object has no attribute 'DATETIME' Here are the stats on the client side: Ubuntu 7.04 Oracle Express 10g Python 2.5.1 Latest cx_ toolset. Server side: Normal 10g -- <admiral> Michael F. March ----- mmarch at gmail dot com "Seriously" - HSR |
From: beki D. <be...@as...> - 2007-08-10 09:52:40
|
B,U,L,L MARKET R_E_PORT!!! Insider B_u_ying A-l-e-r-t!!! Tr Date: Friday, Aug 10, 2007 Com: P-R-I_M_E T.I.M.E GROUP INC Symbol: (P)(R)(T)(H) Cur Pr: $0.105 Thur Close: Gain (19.32%) Recomm: S!trong B.u.y/H.o.l.d DO YOU LOVE T_R-A-D-I-N_G P*ENNY S,T.O,C.K,S? [P][R][T][H] WILL MOVE LIKE A COMET AND ITS ONLY GOING TO GET BETTER! Wat ch this S-U.P-E.RNOVA closely FRIDAY! |
From: lol R. <Rou...@os...> - 2007-08-07 13:40:07
|
e0F3Ca0B |
From: Keegan b. <breese@NOUVEAU-PS.NET> - 2007-04-30 15:38:55
|
You imagine, perhaps, that these States General summoned by M. |
From: christianne M. <chr...@ag...> - 2007-04-29 19:15:22
|
ANLEGER UHR BJ5N.F!!! DIE RALLYE IST GESTARTET Firma: BOERSE INVEST BETEI WKN : 797639 ISIN : CH0012802093 Markt: Frankfurt Kürzel : BJ5N.F Preis: 1.90 5-Tag Prognose: 3.00 KAUFEN KAUFEN KAUFEN! BJ5N.F ESGESCHAFT FIN UNTER PARI! |