what is the best practice to delete the extract files in ogg?
Answer / Santosh Saraswat
The best practice for deleting extract files in Oracle GoldenGate is to use the Purge Utility or set up a scheduled job to purge old extract files based on specific criteria such as age, size, or CSN.
| Is This Answer Correct ? | 0 Yes | 0 No |
I am migrating my oracle database from non-exadata to exadata but my source ogg software and target ogg software versions are different (say source is running ogg 11.1 and target is running ogg 11.2). How can I configure my ogg process to work in such configuration?
list a few parameters which may help improve the replicat performance?
what transaction types does goldengate support for replication?
How can we report on long running transactions?
I have a one-way replication setup. The system administration team wants to apply an os patch to both the ogg source host and the target servers. Provide the sequence of steps that you will carry before and after applying this patch?
my extract was running fine for a long time. All of a sudden it went down. I started the extract processes after 1 hour. What will happen to my committed transactions that occurred in the database during last 1 hour?
what are the steps required to add a new table to an existing replication setup?
if have created a replicate process in ogg 12c and forgot to specify discardfile parameter. What will happen?
what command can be used to view the checkpoint information for the extract process?
what is the minimum database version which supports integrated delivery?
how to configure credential store in ogg 12c?
what are the different encryption levels in aes?