IMPDP multiple schemas with table options

[Sambo8]

Hi all,

I want to run a datapump import using multiple schemas. Is there a way of doing multiple schemas but norows to 1 or 2 tables?

e.g. SCHEMAS=SCHEMA1, SCHEMA2 TABLES=SCHEMA1.TABLE2:norows

Cheers,
Sam

 

[LKBrwnDBA]

You may need to do it in two steps:

1) Import metadata only
2) Import data excluding the tables you do not want



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb