CODEWITHSUNDEEP
sqloracle-databaseoracle11goracle-sqldeveloper
Sanket Parchande
Sanket Parchande

Reputation: 984

How to Load Data from Oracle Crash Dump File to Oracle Database?

I have tried following ways

impdp SYSTEM/ABCD DIRECTORY=E:\OracleDM\dumpFile DUMPFILE=dump_Student.DMP  LOGFILE=dump_Student_imp.log

Upvotes: 1

Views: 612

Answers (1)

Littlefoot
Littlefoot

Reputation: 142720

DIRECTORY is not a real filesystem path to the DMP file - it is an Oracle object. You should create it as SYS, grant privileges to user that is going to use it, and then actually use that directory.

For example:

SQL> show user
USER is "SYS"
SQL> create directory my_dir as 'c:\temp';

Directory created.

SQL> grant read, write on directory my_dir to hr;

Grant succeeded.

At the operating system command prompt:

impdp hr/hr@xe directory=my_dir dumpfile=...

Upvotes: 2

Related Questions