CODEWITHSUNDEEP
databaseoracle-databaseconverters
Fobatai
Fobatai

Reputation: 67

Exporting data from an oracle DMP file

Hope you can help out. I got a DMP file from where i need some tables including the data. (preferable in XLS or separated CSV's)

I found out that it's a oracle database file so i installed oracle express. Now i am trying to get the data imported en then, somehow, export the data to another format.

Is this the right way of doing this? or is there some kinda of tool to do the conversion.

when i try to import it with:

impdp system/retat file=c:\temp\data.dmp

i get the message:

Connected to: Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39088: file name cannot contain a path specification

When i google errors i feel like i am over complicating the problem and tumbling from 1 problem to another. Is there an easy way?

Upvotes: 0

Views: 1354

Answers (1)

onur
onur

Reputation: 6395

You have to create a database directory:

SQL> create directory temp_dir as 'c:\temp\';

And use impdp command like this:

impdp system/retat directory=temp_dir dumpfile=data.dmp

Upvotes: 3

Related Questions