Thanks for the question, imad.
Asked: November 07, 2017 - 7:21 am UTC
Last updated: November 07, 2017 - 12:37 pm UTC
Version: 11.2
Viewed 1000+ times
You Asked
Dears
Hope you are fine,,,
I have a distributed database about 20 branch,,,
each database have the same schema structure
we need a centralized report that reads from only four tables.
currently we take a dump file from each branch and import it to the centralized database.
we are currently evaluating oracle replication, we have some questions.
the tables in the branches databases have the same name, can i replicate those table (with the same name) to a table in the target database with the same name also?
if not possible, can i replicate a table from source database to a table in the target database with different name?
is there any better solution using replication or any other tool.
Regards,
and we said...
Is this answer out of date? If it is, please let us know via a Comment