Can anybody give me answer on this ?
I have two same table names on different oracle databases (different servers also). Database1 has master table called HEADERS and Database2 has also table name called HEADERS. We are updating Database2.HEADERS using the Database1.HEADERS every night. It works fine but few records are missing on Database2.HEADERS. Both the table has 9 primary key columns (like composite primary key).
Which will be the better way to update the HEADERS table of Database2 from using Database1.HEADERS. Please advise asap.
REMEMBER I HAVE 9 PRIMARY KEYS. I HAVE TO USE ALL 9 KEYS & THAT'S HOW IT BECOMES 1 UNIQUE RECORD.
Thanks in advance.
NVS
I have two same table names on different oracle databases (different servers also). Database1 has master table called HEADERS and Database2 has also table name called HEADERS. We are updating Database2.HEADERS using the Database1.HEADERS every night. It works fine but few records are missing on Database2.HEADERS. Both the table has 9 primary key columns (like composite primary key).
Which will be the better way to update the HEADERS table of Database2 from using Database1.HEADERS. Please advise asap.
REMEMBER I HAVE 9 PRIMARY KEYS. I HAVE TO USE ALL 9 KEYS & THAT'S HOW IT BECOMES 1 UNIQUE RECORD.
Thanks in advance.
NVS