Data Pump Import errors
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Data Pump Import errors

  1. #1
    Join Date
    Aug 2007
    Posts
    62

    Data Pump Import errors

    Hi,

    I was unable to import tables using Data Pump.
    It seems to be importing the tables in tablespace AAA (which does not exist) when i specify a remap_tablespace clause to import the tables to tablespace BBB. I've ensure that the default tablespace for my user is tablespace BBB.

    SQL> select default_tablespace from dba_users where username =
    'DATA_USER;

    DEFAULT_TABLESPACE
    ------------------------------
    BBB


    Here's my parfile parameter:
    DIRECTORY=dtpump
    DUMPFILE=expdp_tables.dmp
    LOGFILE=impdp_tables.log
    remap_schema=main_user:data_user
    remap_tablespace=main_user:bbb
    EXCLUDE=STATISTICS

    Here's the error message in the logfile:
    ORA-39083: Object type TABLE failed to create with error:
    ORA-00959: tablespace 'AAA' does not exist

    Any help will be greatly appreciated. Thanks!!!

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    create empty table in desired tablespace, them import it.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    remap_tablespace=aaa:bbb

  4. #4
    Join Date
    Aug 2007
    Posts
    62
    Thanks! It works now!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width