Skip to Main Content

Breadcrumb

Connor and Chris will both be at AI World from October 12 to October 17 , the premier Oracle conference of 2025. If you're in Vegas, please come say Hi or pop into our sessions

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 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
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Utilities

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