Thanks for the question, Reda .
Asked: October 13, 2021 - 8:01 am UTC
Last updated: October 21, 2021 - 2:08 am UTC
Version: 11g
Viewed 1000+ times
You Asked
Dear Ask TOM Team,
Thank you for your appreciated efforts and providing the guidance to all concerned clients.
My question:
I have running and in production oracle DB, 11g ... and would like to import and update the data from other DB with the same structure and version,
Please:
1- provide me the script to do such required import data to the running DB.
2- provide me the script to do such required export data to the running DB.
Regards,
Reda Eltayef
and Connor said...
To *completely* refresh a database (A) with another database (B) you would
- DataPump full export database B
- Drop database A
- Create a new empty database A
- DataPump full import database B
Or just use RMAN to
- backup database B
- drop database A
- Create a new empty database A
- Restore database B into A and rename
If you are interested in just particular schemas then DataPump is probably going to be your only option unless you can use transportable tablespaces.
Hard to advise you on whats best with such little detail.
Is this answer out of date? If it is, please let us know via a Comment