oracle-databaseimportimpdp

how to resolve thousand of errors in oracle import using impdp where I don't know the what parameters were used during expdp?

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.

  1. 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! How can I import the dumpfile without making hundreds of users/roles or tablespaces?

Solution

  • you can generate sql statement using impdp the following way.

    http://www.dba-oracle.com/t_convert_expdp_dmp_file_sql.htm

    then adjust parameter accordingly.

    scott