I have received a dump of a Oracle 11.2.0.2.0 db, which I'd like to export to some readable format like plain text, CSV, excel…
Is that possible in some sort of a simple way? I've found a few converters, but they're not free.
If nothing else, I did just install the latest Oracle Express Edition and Oracle SQL Developer, but I can't seem to find a way to import my .DMP file.
I've tried using the imp and impdp tools, but they both gave me an error:
imp 'sys AS SYSDBA' file=dump.dmp full=yes log=implog.txt
IMP-00038: Could not convert to environment character set's handle
impdp 'sys AS SYSDBA' file=dump.dmp full=yes log=implog.txt
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39088: file name cannot contain a path specification
UPDATE:
It seems I needed to copy the dump to "C:\oraclexe\app\oracle\admin\XE\dpdump" for the IMPDP to work. But now I get the following error message (or maybe just a warning, because as far I see, the tables were created and the data was imported?):
ORA-39083: Object type REFRESH_GROUP failed to create with error:
ORA-23421: job number 1389 is not a job in the job queue
Failing sql is:
BEGIN
dbms_refresh.make('"DB"."TABLE"',list=>null,next_date=>null,interval=>null,implicit_destroy=>TRUE,lax=>FALSE,job=>1389,rollback_seg=>NULL,push_deferred_rpc=>TRUE,refresh_after_errors=>FALSE,purge_option => 1,parallelism => 0,heap_size => 0);
dbms_refresh.add(name=>'"DB"."TABLE"',list=>'"DB"."TABLE"',siteid=>0,export_db=>'XE');
END;
Job "SYS"."SYS_IMPORT_FULL_01" completed with 32 error(s) at 06:59:30
UPDATE 2:
Yeah, I've just checked via Toad for Oracle, and all the data was successfully imported. I also managed to export to excel file using the same application.
Best Answer
First of all you need to create a directory on the database.
Ensure the user that will import the file has the privilige to Read & Write on the directory (In case you are not using SYS)
Then, include the directory parameter within the import statement