"exp vs expdp" & "imp vs impdp"
Dear Friends ,
I have to use expdp and impdp utility for database export and import purpose . I have 2 questions & also have a problem regarding these utilities .
Question :
In Oracle10g Envionment :
1) What is main difference and advantage using 'expdp/impdp' between 'exp/imp' utility .
2) Is it possible to use 'ignore=y' and 'consistant=y' with the 'expdp/impdp' utility ?
Problem :
I have taken my full database using following script :
"expdp system/sys123@rnd directory=test_dir dumpfile=orcl.$Date.dmp full=y logfile=orcl.$Date.log"
My database (Oralce10g) has 21 users :
output : SQL> select username from dba_users;
USERNAME
------------------------------
MGMT_VIEW
SYS
SYSTEM
DBSNMP
SYSMAN
OUTLN
MDSYS
ORDSYS
CTXSYS
ANONYMOUS
EXFSYS
DMSYS
WMSYS
XDB
ORDPLUGINS
SI_INFORMTN_SCHEMA
OLAPSYS
MDDATA
DIP
SCOTT
TSMSYS
21 rows selected.
After taking the export of my database i have to delete "scott" and "XDB" user Like follwoing way :
SQL> drop user scott cascade;
User dropped.
SQL> drop user xdb cascade;
User dropped.
Now when I run the impdp utility :
impdp system/sys123@rnd full=Y directory=test_dir dumpfile=ORCL.$DATE.DMP logfile=impdpDB10G.log
Then I cannot find the 'XDB' user , I just recover my 'scott' user .
Output :(after run 'impdp' utility)
SQL> select username from dba_users;
USERNAME
------------------------------
MGMT_VIEW
SYS
SYSTEM
DBSNMP
SYSMAN
OUTLN
MDSYS
ORDSYS
CTXSYS
ANONYMOUS
EXFSYS
DMSYS
WMSYS
ORDPLUGINS
SI_INFORMTN_SCHEMA
OLAPSYS
MDDATA
DIP
SCOTT
TSMSYS
20 rows selected.
Can anybody plz tell me , after running the 'impdp' utility from my export dump ,Why I only get 'scott' user , not the 'XDB' user ?