I am trying to import an oracle 11g dump file using impdp utility but while doing so, inter alia, I am facing two major errors:
1.
First, It is showing the following error:
"Processing object type DATABASE_EXPORT/TABLESPACE
ORA-39083: Object type TABLESPACE:"HIS_USER" failed to create with error:
ORA-01119: error in creating database file '/oracle/app/oracle/oradata/dwhrajdr1/his_user13.dbf'
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."
so to solve this, I have created the tablesapce with same name but now it is showing that 'HIS_USER' tablespace already exists.
2.
Second, I am getting thousands of errors, where it is showing user or role does not exist:
"Failing sql is:
GRANT EXECUTE ANY ASSEMBLY TO "DSS"
ORA-39083: Object type SYSTEM_GRANT failed to create with error:
ORA-01917: user or role 'DSS' does not exist"
Please suggest how to solve these errors!
1. You know you've created the tablespace, so you could just ignore this error. Or you could exclude the tablespaces from the import.
2. Similarly for the grant errors, you can either:
- Ignore them
- Re-reun the export add include the necessary users
- Create the users beforehand
- Exclude grants the import
I'm wary of excluding the grants; if you're uncomfortable ignoring the errors it's better to create the users with one of the second two options.