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.