This discussion is archived
8 Replies Latest reply: Apr 2, 2013 4:57 AM by 947771 RSS

what are other thing should i consider using expdp and impdp

947771 Newbie
Currently Being Moderated
(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’;

from windows command line.

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

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


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