expdp and impdp tablespace on same database
Just a example for export tablespace and import tablespace on the same database when the tablespace existing
Step1 :
Step 2: export tabespace
Step 3: import tablespace but errors shown when it ends because of already existing objects there
Step 4: use table_exists_action=replace
One Comment
Post a comment
DBA 
hi, thanks for writing such an valuable post i have got en error when i :
C:\>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue May 15 16:15:24 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to an idle instance.
SQL> startup ORACLE instance started. Total System Global Area 778387456 bytes Fixed Size 1374808 bytes Variable Size 444597672 bytes Database Buffers 327155712 bytes Redo Buffers 5259264 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 4732
Session ID: 9 Serial number: 5
i got this error, any solution .
thanks in advance.