Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Is is possible to import a specific view with impdp and the INCLUDE clause?

JSebastianFeb 16 2010 — edited Feb 16 2010

I have a full database export dumpfile and I want to import a specific view definition in a specific schema from that file. I'm trying to use the INCLUDE clause and having trouble.

$ impdp uname/pwd include=VIEW:"='OPS\$oj46860.V_PUBDATA'" dumpfile=EXPDIR:ORADB1_full_export_2010-01-29_18:00:01.dmp
LRM-00116: syntax error at 'VIEW:' following '='

I try it without the schema name in front of it but get the same error:
$ impdp uname/pwd include=VIEW:"='V_PUBDATA'" dumpfile=EXPDIR:ORADB1_full_export_2010-01-29_18:00:01.dmp
LRM-00116: syntax error at 'VIEW:' following '='

I try using the LIKE instead of = in the INCLUDE clause:
$ impdp uname/pwd include=VIEW:" LIKE 'OPS$OJ46860.V_PUBDATA'" dumpfile=EXPDIR:ORADB1_full_export_2010-01-29_18:00:01.dmp
UDI-00014: invalid value for parameter, 'include'

If I try LIKE without the schema name, I get the same error
$ impdp uname/pwd include=VIEW:" LIKE 'V_PUBDATA'" dumpfile=EXPDIR:ORADB1_full_export_2010-01-29_18:00:01.dmp
UDI-00014: invalid value for parameter, 'include'

Any help is appreciated. I don't see in the Utilities manual a definition of the object_type for the INCLUDE statement. I assume that 'VIEW' is a correct object type.