Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question

migrated from stackoverflow.com Aug 30 '12 at 12:42

This question came from our site for professional and enthusiast programmers.

    
What line did you run in order to generate the errors? –  Ben Aug 29 '12 at 12:40
1  
Do you have NLS_LANG set? How did you receive the file - it's a binary format so it it possible it's been corrupted by an ASCI FTP or similar? Does running imp with show=y give you anything? –  Alex Poole Aug 29 '12 at 13:54
    
@Ben I've updated the question. @AlexPoole I don't know. I've received it through email. show=y gives me the exact same error as before. –  Howie Aug 30 '12 at 4:53
    
You have to create a directory first. In sqlplus: create directory IMPDIR as '/path/to/the/file';. Then repeat your previous impdp command-line, but add the parameter DIRECTORY=IMPDIR –  Phil Aug 30 '12 at 14:46
1  
ORA-39088: file name cannot contain a path specification indicates that your file name specification contains a path specification like file=C:\dump.dmp or something similiar. In your post the impdp command did not have such a path specification. This is strange. Do you show us the real command or did you remove the path in your post? –  miracle173 Aug 31 '12 at 1:45
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.