Home » RDBMS Server » Server Utilities » Is there a way to import different database dump into a RAC database (11.2.0.3 SE, SLES 11 SP3)
Is there a way to import different database dump into a RAC database [message #626363] Mon, 27 October 2014 05:24 Go to next message
juniordbanewbie
Messages: 250
Registered: April 2014
Senior Member
Hi all,

I've a dump file dumped from A RAC database with ORACLE_UNQNAME=orcl, i need to import them into a RAC database with ORACLE_UNQNAME=nowatz

my parameter file is as follow


FULL=Y
DIRECTORY=DATA_PUMP_DIR
DUMPFILE=full_export.dmp
LOGFILE=impdp_full_20141027_1740.log
JOB_NAME=impdp_full

partial log file is as follow

CREATE TABLESPACE "UAT" DATAFILE '+DATA/orcl/datafile/uat_001.dbf' SIZE 2097152 AU
TOEXTEND ON NEXT 2097152 MAXSIZE 52428800 LOGGING ONLINE PERMANENT BLOCKSIZE 819
2 EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT NOCOMPRESS  SEGMENT
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file '+DATA/orcl/datafile/respos_001.dbf'
ORA-17502: ksfdcre:4 Failed to create file +DATA/orcl/datafile/respos_001.dbf
ORA-15173: entry 'orcl' does not exist in directory '/'



Is there a way to resolve the above errors other than these two solutions:

create a directory orcl at the root of Diskgroup DATA
rename the database nowatz into orcl.

thanks a lot!
Re: Is there a way to import different database dump into a RAC database [message #626365 is a reply to message #626363] Mon, 27 October 2014 05:29 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Pre-create the tablespaces and add "EXCLUDE=TABLESPACE" option.

Previous Topic: sqlldr-how to generate log file for all files loaded
Next Topic: escape double-quotes in sqlldr
Goto Forum:
  


Current Time: Thu Mar 28 16:20:34 CDT 2024