OraFAQ Forum: Server Utilities » expdp where clause with subquery

Home » RDBMS Server » Server Utilities » expdp where clause with subquery (11gR2 Linux)

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

expdp where clause with subquery [message #566789]

Wed, 19 September 2012 09:53

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

I have this query fetch 1000 records .


select count(*) from SCOTT.MYTABLE tb
where not exists 
(select * from SCOTT.MYTABLE tb ,SCOTT.MYTABLE tb_in where
tb_in.rowid= tb.rowid
and
 (col1= 'Status' and col2 = 'property'));

Can someone tell me how to do a where clause export using QUERY option ,of this 1000 records.

Report message to a moderator

Re: expdp where clause with subquery [message #566791 is a reply to message #566789]

Wed, 19 September 2012 10:09

Michel Cadot
Messages: 68352
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You can't.

Regards
Michel

Report message to a moderator

Re: expdp where clause with subquery [message #566795 is a reply to message #566789]

Wed, 19 September 2012 11:08

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Mike, just curious .. What is the reason . Only simple SELECTs are allowed ?

Report message to a moderator

Re: expdp where clause with subquery [message #566798 is a reply to message #566795]

Wed, 19 September 2012 11:25

Michel Cadot
Messages: 68352
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

But WHERE parameter is not a SELECT.
Create a TABLE (or a MVIEW if you have to do it often) with the result and export it.

Regards
Michel

Report message to a moderator

Re: expdp where clause with subquery [message #566803 is a reply to message #566798]

Wed, 19 September 2012 11:38

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

Great. Thanks Mike.

Report message to a moderator

Previous Topic:	importing dump file error
Next Topic:	Inserting targz files into table from specified folder

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 08 07:30:23 CST 2023