DevSupport
asked on
copies database tables from one database to another
i have a requirement of copying three tables from an Oracle database and dump it into another Oracle database.
Copy tables A, B, C from the source database and put it into Destination database as copies of master table A1, B1, C1...next day A2, B2, C2..and so on. This needs to happen daily.
The destination database may have these tables as unique copies for each day, to prevent overwriting..
What is the best way to do it? Should we use datapump exp/imp? if so how to write the query so that the destination database table will not be overwritten.
I am totally new to Oracle sorry.. I can share the table details if needed.
Copy tables A, B, C from the source database and put it into Destination database as copies of master table A1, B1, C1...next day A2, B2, C2..and so on. This needs to happen daily.
The destination database may have these tables as unique copies for each day, to prevent overwriting..
What is the best way to do it? Should we use datapump exp/imp? if so how to write the query so that the destination database table will not be overwritten.
I am totally new to Oracle sorry.. I can share the table details if needed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!