5 Replies Latest reply: Jan 9, 2011 11:18 PM by Chinar RSS

    IMPdp

    JIC
      Hi..
      Plz help to solve these error...
      When I tried to impdp for new database...its giving follwoing error...
      c:\ impdp directory=exp_dir dumpfile=SUNDAY.DMP logfile=sunday_imp.log full=y



      Import: Release 10.2.0.4.0 - Production on Monday, 10 January, 2011 7:21:07

      Copyright (c) 2003, 2007, Oracle. All rights reserved.
      ;;;
      Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options
      Master table "SYSTEM"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
      Starting "SYSTEM"."SYS_IMPORT_FULL_01": system/******** directory=exp_dir dumpfile=SUNDAY.DMP logfile=sunday_test_imp.log full=y
      Processing object type DATABASE_EXPORT/TABLESPACE
      ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
      ORA-31684: Object type TABLESPACE:"SYSAUX" already exists
      ORA-31684: Object type TABLESPACE:"TEMP" already exists
      ORA-31684: Object type TABLESPACE:"USERS" already exists
      ORA-39083: Object type TABLESPACE failed to create with error:
      ORA-01119: error in creating database file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIC\ACCOUNTABILITY01.DAT'
      ORA-27040: file create error, unable to create file
      OSD-04002: unable to open file
      O/S-Error: (OS 3) The system cannot find the path specified.
      Failing sql is:
      CREATE TABLESPACE "ACCOUNTABILITY_DAT" DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIC\ACCOUNTABILITY01.DAT' SIZE 10485760 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M LOGGING ONLINE PERMAN
      ORA-39083: Object type TABLESPACE failed to create with error:
      ORA-01119: error in creating database file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIC\ACCOUNTABILITY01.IDX'
      ORA-27040: file create error, unable to create file
      OSD-04002: unable to open file
      O/S-Error: (OS 3) The system cannot find the path specified.
      Failing sql is:
      CREATE TABLESPACE "ACCOUNTABILITY_IDX" DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIC\ACCOUNTABILITY01.IDX' SIZE 10485760 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M LOGGING ONLINE PERMAN
      ORA-39083: Object type TABLESPACE failed to create with error:
      ORA-01119: error in creating database file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIC\ACQUISITION01.DAT'
      ORA-27040: file create error, unable to create file
      OSD-04002: unable to open file
      O/S-Error: (OS 3) The system cannot find the path specified.
      Failing sql is:
      CREATE TABLESPACE "ACQUISITION_DAT" DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIC\ACQUISITION01.DAT' SIZE 10485760 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCK
      ORA-39083: Object type TABLESPACE failed to create with error:
      ORA-01119: error in creating database file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIC\ACQUISITION01.IDX'
      ORA-27040: file create error, unable to create file
      OSD-04002: unable to open file
      O/S-Error: (OS 3) The system cannot find the path specified.
      Failing sql is:
      CREATE TABLESPACE "ACQUISITION_IDX" DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIC\ACQUISITION01.IDX' SIZE 10485760 AUTOEXTEND ON NEXT 8192 MAXSIZE 32767M LOGGING ONLINE PERMANENT BLOCK
      ORA-39083: Object type TABLESPACE failed to create with error:
      ORA-01119: error in creating database file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIC\ADMINISTRATION01.DAT'
      ORA-27040: file create error, unable to create file
      OSD-04002: unable to open file
      ..........................
        • 1. Re: IMPdp
          sb92075
          ORA-01119: error in creating database file 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIC\ACCOUNTABILITY01.DAT'
          does D:\ volume exist along with specified directory tree on the new system?
          • 2. Re: IMPdp
            JIC
            Actually..my directory location is..
            D:\ORACLE\PRODUCT\10.2.0\UNIC\USERS01.DBF <-----for newdb
            my old db directory location is:
            D:\ORACLE\PRODUCT\10.2.0\ORADATA\UNIC\ <-------old db
            • 3. Re: IMPdp
              JIC
              My dear friends...Now it successful...
              I have don mistake...
              In old EXPDP file my file location is differ and new database file location diff..Now I created as per as old database directory..now its k...

              Thanks very much..
              • 4. Re: IMPdp
                sb92075
                Now I created as per as old database directory..now its k...
                impdp help=yes
                impdp has a number of REMAP options to automagically handle changes between old & new system/database.
                • 5. Re: IMPdp
                  Chinar
                  Your target and source database file names path(also name) are different.So to solving problem you have to create ACCOUNTABILITY_DAT tablespace in source(imported database) before import.After creating this tablespace you can import.