This discussion is archived
4 Replies Latest reply: Aug 30, 2013 12:54 PM by Richard Harrison . RSS

Not able to export views using expdp with include parameter

maggie Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points