Exporting oracle schema using datadump -
i took export of schema xxx has default tablespace test01. while importing dmp of schema xxx database in tablespace test01 not present. import run successfully?
you can use remap_tablespace
:
impdp user/password directory=your_dir dumpfile=your_dmp schema=your_sch remap_tablespace=old_tbs:new_tbs
Comments
Post a Comment