Forum Stats

  • 3,855,187 Users
  • 2,264,469 Discussions
  • 7,905,917 Comments

Discussions

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

822592
822592 Member Posts: 1
edited Dec 10, 2010 9:04AM in GoldenGate
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

Answers

This discussion has been closed.