OGG-00665 OCI Error executing statement (status = 1008-ORA-01008: not all
822592Dec 9 2010 — edited Dec 10 2010Simply trying to move the data from table data from point A to point B.
Schema name, table name/structure is exactly same. Source is Solaris & target is Linux.
When I try enabling the extract, I get this error:-
-----------------------------------------------------------------------
Source Context :
SourceModule : [ggdb.ora.sess]
SourceID : [home/ecloud/workspace/Build_FBO_OpenSys_r11.1.1.0.0_078_[34085]/perforce/src/gglib/ggdbora/ocisess.c]
SourceFunction : [OCISESS_try]
SourceLine : [499]
2010-12-08 16:47:42 ERROR OGG-00665 OCI Error executing statement (status = 1008-ORA-01008: not all variables bound), SQL< SELECT c.constraint_name, c.column_name FROM all_cons_columns c WHERE c.owner = :owner1 AND c.table_name = :table1 AND c.constraint_name = (SELECT c1.name FROM>.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2010-12-08 16:47:42 (activity since 2010-12-08 16:39:03)
Output to ./dirdat/em:
No records extracted.
2010-12-08 16:47:42 ERROR OGG-01668 PROCESS ABENDING.
-------------------------------------------------------------------------------------------------------------------------------
Any help on this is highly appreciated.
Thanks,
Murtaza