Oracle Data Pump import to a sql file error :ORA-31655 no data or metadata objects

Posted by Francisco Quiñones on Stack Overflow See other posts from Stack Overflow or by Francisco Quiñones
Published on 2010-01-26T14:40:18Z Indexed on 2010/06/11 7:02 UTC
Read the original article Hit count: 376

Filed under:
|
|

Hello, I'm using Data Pump to export/import data, one requirement is to import data to a sql file. The OS is window. I made the follow export :

expdp system/password directory=dpump_dir dumpfile=tablesdump.dmp content=DATA_ONLY tables=user.tablename

and it works, I can see the file TABLESDUMP.DMP in the directory path.

then when I tried to import it to a sql file:

impdp system/password directory=dpump_dir dumpfile=tablesdump.dmp sqlfile=tables_export.sql

the log show :

.....
ORA-31655 no data or metadata objects selected for job
.....

and the sql file is created empty in the directory path.

I'm not DBA, I'm a Java developer , Can you help me?

Thks

© Stack Overflow or respective owner

Related posts about Oracle

Related posts about import