DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2012

    How to use REMAP_DATAFILE with IMPDP

    I'm a SQL DBA, so pretty new to Oracle.

    I'm trying to restore a database using impdp (it was created using expdp).

    Here's my impdp statement:

    impdp system/oracle full=y directory=ATA_PUMP_IR dumpfile=IRISexp%U.dmp remap_datafile=/'+PDATA/iris/datafile/undotbs2.302.699230857/':\'D:\NickL\App\oradata\DT_IRIS_EXPORT_2012\DATAFILE\undotbs2.302.699230857'/
    This is the error I get:

    ORA-39083: Object type TABLESPACE failed to create with error:
    ORA-01276: Cannot add file +PATA/iris/datafile/undotbs2.302.6992308597. File has an Oracle Managed Files files name.
    Any help would be appreciated, thanks

  2. #2
    Join Date
    Dec 2002
    If you are using Oracle Managed datafile, then just skip the remap_datafile option.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.