Skip to Main Content

GoldenGate

OGG-00665 OCI Error executing statement (status = 1008-ORA-01008: not all

822592Dec 9 2010 — edited Dec 10 2010
Simply 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2011
Added on Dec 9 2010
1 comment
1,431 views