Skip to content
Advertisements

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

Advertisements
One Comment Post a comment
  1. abdul #

    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.

    May 15, 2012

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: