Home » RDBMS Server » Server Utilities » Exporting DB schemas / tables without data
Exporting DB schemas / tables without data [message #476297] Wed, 22 September 2010 09:39 Go to next message
Sepph
Messages: 14
Registered: September 2010
Junior Member
Hi,

I'm trying to export a relatively large database but it's a bit more complicated than that.

For one schema I need a full export / import (data included).

For another 10 schemas I need them empty, with the exception of a table in some of them which needs to be exported / imported with all data inside.

Is it possible to do this with datapump utility (impdp, expdp)?

Afterwards I will be running some scripts to populate the DB instance with critical data / metadata.

Some links to comprehensive guides would also be appreciated.
Re: Exporting DB schemas / tables without data [message #476299 is a reply to message #476297] Wed, 22 September 2010 09:44 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes, do it in several steps.

Regards
Michel
Previous Topic: Need help with schema export
Next Topic: Tablespace for Importing objects.
Goto Forum:
  


Current Time: Mon Dec 23 10:13:26 CST 2024