EXPDP – ORA-39166: Object XXX was not found.

SQL> create table scott."test" as select * from scott.dept; Table created. SQL> select * from scott.TEST; select * from scott.TEST * ERROR at line 1: ORA-00942: table or view does not exist SQL> select * from scott.test; select * from scott.test * ERROR at line 1: ORA-00942: table or view does not exist SQL> select … Continue reading EXPDP – ORA-39166: Object XXX was not found.

Advertisement

ERROR -OGG-00446 -Oracle GoldenGate Capture for Oracle: No valid log files for current redo sequence XXX, thread X

I was trying to setup Oracle GoldenGate (OGG) on my test box having 11gR2 database with ASM. On starting the extract process on the source showed - GGSCI (anand-lab) 6> START EXTRACT ext1 Sending START request to MANAGER ... EXTRACT EXT1 starting GGSCI (anand-lab) 7> INFO EXTRACT ext1 EXTRACT EXT1 Initialized 2011-07-17 14:22 Status STOPPED … Continue reading ERROR -OGG-00446 -Oracle GoldenGate Capture for Oracle: No valid log files for current redo sequence XXX, thread X

ERROR: No checkpoint table specified for ADD REPLICAT – Oracle GoldenGate

This is just a quick note for myself to remember and reference for in case someone comes across this error while setting up Oracle GoldenGate. While configuring the online synchronization replication, a default checkpoint table is created.The table's name is mentioned in file named GLOBALS. GGSCI (anand-lab) 29> EDIT PARAMS ./GLOBALS GGSCHEMA GG_OWNER CHECKPOINTTABLE GG_OWNER.CKPTAB … Continue reading ERROR: No checkpoint table specified for ADD REPLICAT – Oracle GoldenGate