4 Replies Latest reply: Aug 30, 2013 2:54 PM by Richard Harrison . RSS

    Not able to export views using expdp with include parameter

    maggie

      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