search

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.
http://www.ora2pg.com/
GNU General Public License v3.0
1.03k stars 341 forks source link

Error during Copy data of the Database ( All schema ) #701

Closed Barzaqh closed 6 years ago

Barzaqh commented 6 years ago

Hi ,

i have this error when i used ora2pg with parameter -j 8 and -J 8 for all schema DB , oracle :

here command line : 

ora2pg -j 8 -J 8 -t COPY -o data.sql -b $namespace/data -c $namespace/config/ora2pg.conf

i have this error message : 

DBD::Oracle::db prepare failed: ORA-24338: statement handle not executed (DBD ERROR: OCIAttrGet OCI_ATTR_PARAM_COUNT) [for Statement "SELECT DISTINCT OBJECT_NAME,OWNER,OBJECT_ID FROM ALL_OB
JECTS WHERE OBJECT_TYPE='TYPE' AND STATUS='VALID' AND **OBJECT_NAME='INTERVAL DAY(9) TO SECOND(3)'** AND GENERATED='N'AND OWNER NOT IN ('CAT_USER','DBGWATCH','SYS','SYSTEM','U326829','U332211','U351086','U358872','U517194','U519086','U519133','U519144','U519149','U519194','U522606','U522622','SYSTEM','CTXSYS','DBSNMP','E
XFSYS','LBACSYS','MDSYS','MGMT_VIEW','OLAPSYS','ORDDATA','OWBSYS','ORDPLUGINS','ORDSYS','OUTLN','SI_INFORMTN_SCHEMA','SYS','SYSMAN','WK_TEST','WKSYS','WKPROXY','WMSYS','XDB','APEX_PUBLIC_USER','DIP','FLOWS_020100','FLOWS_030000','FLOWS_040100','FLOWS_010600','FLOWS_FILES','MDDATA','ORACLE_OCM','SPATIAL_CSW_ADMIN_USR','SPATIAL_WFS_ADMIN_USR','XS$NULL','PERFSTAT','SQLTXPLAIN','DMSYS','TSMSYS','WKSYS','APEX_040200','DVSYS','OJVMSYS','GSMADMIN_INTERNAL','APPQOSSYS','DVSYS','DVF','AUDSYS','APEX_030200','MGMT_VIEW','ODM','ODM_MTR','TRACESRV','MTMSYS','OWBSYS_AUDIT','WEBSYS','WK_PROXY','OSE$HTTP$ADMIN','AURORA$JIS$UTILITY$','AURORA$ORB$UNAUTHENTICATED','DBMS_PRIVILEGE_CAPTURE','CSMIG')  ORDER BY OBJECT_NAME"] at /usr/local/share/perl5/Ora2Pg.pm line 107
50.
FATAL: ORA-24338: statement handle not executed (DBD ERROR: OCIAttrGet OCI_ATTR_PARAM_COUNT)

if i export 1 schema it works also i decrease the number of paralle : ora2pg -j 2 -J 2 . I would like to use the parallel process .

when i launched this query , i saw 0 rows when i removed this filter "interval day ... ." , i have a result .

brgds , Thanks for your help

Hassan

darold commented 6 years ago

Ora2pg is not responsible of the filter OBJECT_NAME='INTERVAL DAY(9) TO SECOND(3)', what Ora2Pg version are you using? Do you have the same issue with the last release?