OraFAQ Forum: Server Utilities » Expdp using query

Home » RDBMS Server » Server Utilities » Expdp using query (oracle 11.2.0.4 ,RHEL 5.9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Expdp using query [message #635720]

Tue, 07 April 2015 07:56

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

Report message to a moderator

Re: Expdp using query [message #635721 is a reply to message #635720]

Tue, 07 April 2015 08:03

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Expdp using query [message #635947 is a reply to message #635720]

Mon, 13 April 2015 09:50

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

Report message to a moderator

Re: Expdp using query [message #635957 is a reply to message #635947]

Tue, 14 April 2015 01:24

ultimatesr
Messages: 2
Registered: April 2015

Junior Member

Thank you LKBrwn_DBA Smile

Report message to a moderator

Previous Topic:	Import and create table from a text file
Next Topic:	How to Import Data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 07 00:48:14 CST 2025