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
Messages: 14
Registered: September 2010
Junior Member

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: 68510
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, do it in several steps.

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

Current Time: Tue Oct 03 09:11:54 CDT 2023