Home » RDBMS Server » Server Utilities » Expdp using query (oracle 11.2.0.4 ,RHEL 5.9)
Expdp using query [message #635720] Tue, 07 April 2015 07:56 Go to next message
ultimatesr
Messages: 2
Registered: April 2015
Junior Member
I'm trying to export few tables using the query option but I'm not able to do so.when i deleted the data in the table it got exported successfully .
Contents in my parfile are as follows:
schemas=TESTME_DD
directory=TEST
include=TABLE
content=all
query="where object_name like 'TABL%'"
dumpfile=test_exp.dmp
logfile=test_exp.log

It shows an error like:
ORA-31693: Table data object "TESTME_DD"."TABLE1" failed to load/unload and is being skipped due to error:
ORA-00904: "OBJECT_NAME": invalid identifier
ORA-31693: Table data object "TESTME_DD"."TABLE2" failed to load/unload and is being skipped due to error:
ORA-00904: "OBJECT_NAME": invalid identifier



Re: Expdp using query [message #635721 is a reply to message #635720] Tue, 07 April 2015 08:03 Go to previous messageGo to next message
BlackSwan
Messages: 26538
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

QUERY is for row selection within tables; not for determining which tables are exported.

https://docs.oracle.com/database/121/SUTIL/dp_export.htm#SUTIL860
icon10.gif  Re: Expdp using query [message #635947 is a reply to message #635720] Mon, 13 April 2015 09:50 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL
Senior Member
Try:
schemas=TESTME_DD
directory=TEST
TABLES='TABL%'
content=all
dumpfile=test_exp.dmp
logfile=test_exp.log

Cool
Re: Expdp using query [message #635957 is a reply to message #635947] Tue, 14 April 2015 01:24 Go to previous message
ultimatesr
Messages: 2
Registered: April 2015
Junior Member
Thank you LKBrwn_DBA Smile
Previous Topic: Import and create table from a text file
Next Topic: How to Import Data
Goto Forum:
  


Current Time: Sat Jun 15 17:37:24 CDT 2019