What Is The Best Practice To Delete The Extract Files In Ogg? – InterviewSolution

1.

What Is The Best Practice To Delete The Extract Files In Ogg?

Answer»

USE the manager PROCESS to delete the extract files after they are consumed by the extract/replicat process

PURGEOLDEXTRACTS /u01/app/oracle/dirdat/et*, USECHECKPOINTS, MINKEEPHOURS 2

Use the manager process to delete the extract files after they are consumed by the extract/replicat process

PURGEOLDEXTRACTS /u01/app/oracle/dirdat/et*, USECHECKPOINTS, MINKEEPHOURS 2

Discussion

No Comment Found

Related InterviewSolutions

We Want To Setup One-way Data Replication For My Online Transaction Processing Application. However There Are Compressed Tables In The Environment. Please Suggest How I Can Achieve It?
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?
What Are The Different Ogg Initial Load Methods Available?
I Have A Table Called ‘test’ On Source And Target With Same Name, Structure And Data Type But In A Different Column Order. How Can You Setup Replication For This Table?
What Is The Best Practice To Delete The Extract Files In Ogg?
What Parameters Can Be Used To Configure Oracle Goldengate To Extract Data From Archived Redo Log Files Only?
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?
What Are The Basic Resources Required To Configure Oracle Goldengate High Availability Solution With Oracle Clusterware?
What Is The Purpose Of The Defgen Utility?
How Do You Create A Csv File From The Extracted Data?