Exporting DB schemas / tables without data [message #476297] |
Wed, 22 September 2010 09:39 |
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.
|
|
|
|