How to use REMAP_DATAFILE with IMPDP
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to use REMAP_DATAFILE with IMPDP

  1. #1
    Join Date
    Oct 2012
    Posts
    1

    How to use REMAP_DATAFILE with IMPDP

    Hi,
    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:

    Code:
    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:

    Code:
    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
    Posts
    60
    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