Home » RDBMS Server » Server Utilities » expdp where clause with subquery (11gR2 Linux)
expdp where clause with subquery [message #566789] Wed, 19 September 2012 09:53 Go to next message
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.
Re: expdp where clause with subquery [message #566791 is a reply to message #566789] Wed, 19 September 2012 10:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: expdp where clause with subquery [message #566795 is a reply to message #566789] Wed, 19 September 2012 11:08 Go to previous messageGo to next message
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 ?
Re: expdp where clause with subquery [message #566798 is a reply to message #566795] Wed, 19 September 2012 11:25 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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
Re: expdp where clause with subquery [message #566803 is a reply to message #566798] Wed, 19 September 2012 11:38 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Great. Thanks Mike.
Previous Topic: importing dump file error
Next Topic: Inserting targz files into table from specified folder
Goto Forum:
  


Current Time: Thu Mar 28 05:53:08 CDT 2024