What Is The Purpose Of The Defgen Utility?

1.	What Is The Purpose Of The Defgen Utility?
Answer» When the source and the target schema objects are not the same (different DDL’s) the REPLICAT process needs to KNOW the source definition of the objects. The OUTPUT from the DEFGEN utility is USED in conjunction with the trail data to determine which column VALUE in the trail belongs to which column. When the source and the target schema objects are not the same (different DDL’s) the Replicat process needs to know the source definition of the objects. The output from the DEFGEN utility is used in conjunction with the trail data to determine which column value in the trail belongs to which column.

Answer»

When the source and the target schema objects are not the same (different DDL’s) the REPLICAT process needs to KNOW the source definition of the objects. The OUTPUT from the DEFGEN utility is USED in conjunction with the trail data to determine which column VALUE in the trail belongs to which column.

When the source and the target schema objects are not the same (different DDL’s) the Replicat process needs to know the source definition of the objects. The output from the DEFGEN utility is used in conjunction with the trail data to determine which column value in the trail belongs to which column.

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?