troubleshooting Question

Problem Using REMAP_DATAFILE=

Avatar of xoxomos
xoxomos asked on
Oracle Database
9 Comments1 Solution6961 ViewsLast Modified:
I'm trying to import remapping datafiles using this parameter file.

directory=datapump_directory
full=y
dumpfile=BB4_BB60.dmp
logfile=import_bblearn.log
REMAP_DATAFILE='/u02/app/oracle/oradata/BB60/bbadmin_data_file1.dbf':'/data/BBLEARN/bbadmin_data_file1.dbf'
REMAP_DATAFILE='/u02/app/oracle/oradata/BB60/bbadmin_indx_file1.dbf':'/indexes/BBLEARN/bbadmin_indx_file1.dbf'
REMAP_DATAFILE='/u02/app/oracle/oradata/BB60/bb_bb60_data_file1.dbf':'/data/BBLEARN/bb_bb60_data_file1.dbf'
REMAP_DATAFILE='/u02/app/oracle/oradata/BB60/bb_bb60_data_file2.dbf':'/data/BBLEARN/bb_bb60_data_file2.dbf'
REMAP_DATAFILE='/u02/app/oracle/oradata/BB60/bb_bb60_data_file3.dbf':'/data/BBLEARN/bb_bb60_data_file3.dbf'
REMAP_DATAFILE='/u02/app/oracle/oradata/BB60/bb_bb60_data_file4.dbf':'/data/BBLEARN/bb_bb60_data_file4.dbf'

I get failing sql

Failing sql is:
CREATE TABLESPACE "BBADMIN_DATA" DATAFILE '/u02/app/oracle/oradata/BB60/bbadmin_data_file1.dbf' SIZE 52428800 AUTOEXTEND ON NEXT 131072 MAXSIZE 2097152000 LOGGING ONLINE PERMANENT BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01119: error in creating database file '/u02/app/oracle/oradata/BB60/bbadmin_indx_file1.dbf'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory

There is no /u02 on the new server.  I'm saying remap to /data.
What do i need to do to get rid of this error?  Must there be a /u02/.../.../  before I can remap?

ASKER CERTIFIED SOLUTION
xoxomos

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros