8 Replies Latest reply: Apr 2, 2013 6:57 AM by 947771 RSS

    what are other thing should i consider using expdp and impdp

    947771
      (11g express) r2 windows 2008 and also xp ( i installed it at two places for testing.)

      i wanted to make backup of one schema

      so i used expdp

      please tel me is it ok or is there any thing more reliable to make backup of a schema and import(impdp) of a schema to any oracle database.


      from window prompt
      MKDIR c:\oraclexe\app\tmp
      from sql plus


      sqlplus SYSTEM/password

      CREATE OR REPLACE DIRECTORY dmpdir AS ’c:\oraclexe\app\tmp’;
      GRANT READ,WRITE ON DIRECTORY dmpdir TO hr;

      from windows command line.

      expdp SYSTEM/password SCHEMAS=hr DIRECTORY=dmpdir DUMPFILE=schema.dmp
      LOGFILE=expschema.log

      then following to import

      impdp SYSTEM/password SCHEMAS=hr DIRECTORY=dmpdir DUMPFILE=schema.dmp
      REMAP_SCHEMA=hr:hrdev EXCLUDE=constraint, ref_constraint, index
      TABLE_EXISTS_ACTION=replace LOGFILE=impschema.log


      2) pls tel me should i consider any thing else while exporting or importing.

      3) i have removed EXCLUDE=constraint, ref_constraint, index because i need constrainta index etc.
      so pls tel me why in documentation it is written.


      yours sincerely

      Edited by: 944768 on Mar 31, 2013 2:02 AM