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
3,536 views last month, 2 views today