Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

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 100+ 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.

More to Explore

Utilities

All of the database utilities are explained in the Utilities guide.