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

oracle import datapump
Francisco Quiñones picture Francisco Quiñones · Jan 26, 2010 · Viewed 13.2k times · Source

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

Answer

Francisco Quiñones picture Francisco Quiñones · Jan 26, 2010

Since I exported the data using the parameter 'content=data_only' the dump file has not metadata info to be imported. I tried export with 'content=all' parameter and then import to sql file worked. I hope this be helpful for other cases.

Thanks to Anurag Tibrewa.

Related questions

Why do I get ORA-39001: invalid argument value when I try to impdp in Oracle 12c?

When I run this command in Oracle 12c SE2: impdp system/Oracle_1@pdborcl directory=DATA_PUMP_DIR dumpfile=mydb.dmp nologfile=Y I get this: ORA-39001 : invalid argument value ORA-39000 : bad dump file specification ORA-39088 : directory name DATA_PUMP_DIR …

Read More
Oracle: Import CSV file

I've been searching for a while now but can't seem to find answers so here goes... I've got a CSV file that I want to import into a table in Oracle (9i/10i). Later on I plan to use this …

Read More
Migrate from Oracle to MySQL

We ran into serious performance problems with our Oracle database and we would like to try to migrate it to a MySQL-based database (either MySQL directly or, more preferably, Infobright). The thing is, we need to let the old and …

Read More