Site icon IT Tutorial

Table Based GoldenGate initial load

Hello, I will explain how to make Table-based Goldengate initial load and the points to be considered.

In this article, the point to be considered while exporting is flashback scn, in the meantime, flashback scn snapshot of the database needs to be taken.

select dbms_flashback.get_system_change_number from dual;
SELECT CURRENT_SCN FROM V$DATABASE;

After getting flashback scn we can start export shoulder

expdp "'/ as sysdba'" DIRECTORY=TP_DIR dumpfile=Test.load.dmp logfile=Test.load.log cluster=no parallel=2 TABLES=Test.deneme,Test.deneme2,Test.deneme3,Test.deneme4 flashback_scn=16469693058776
Exit mobile version