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!

Not able to export views using expdp with include parameter

maggieAug 28 2013 — edited Aug 30 2013

Greetings,

I need to export using expdp a list of 10 tables and 10 views using parfile method using oracle 11g client. I am able to export the tables but not the views in the export. I did not see the views when I did import. Am I using the right syntax? Any additional parameters are needed or do I need to write the parfile in any other way? Please help me.

My Expdp command has

expdp UN/PW@DB parfile=par_exp.prm"

Par file has following

DIRECTORY=DUMP_FILE

SCHEMAS=ABC

INCLUDE=TABLE:"IN (

'DOCUMENT1',

'DOCUMENT2')"

INCLUDE=VIEW:"IN (

'DOCUMENT1_VW',

'DOCUMENT2_VW'

PARALLEL=4

DUMPFILE=data_export_%U.dmp

LOGFILE=data_export.LOG

Thanks in advance

Maggie

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2013

Added on Aug 28 2013

#database-key-features, #export-import-sql-loader-external-tables

4 comments

2,831 views