IMPdp
JICJan 9 2011 — edited Jan 10 2011Hi..
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
..........................