Hi Vikas,
You can do this.
The syntax is like this exp userid=scott/tiger tables=(emp,emp10)
query=\"where empno=7900\"
It will export matching rows from emp and emp10 tables.
Thanks and regards.
--Sukhamoy.

Bhat Vikas wrote:

>Hi Pradhan,
>
>AFAIK, you cannot use where filter in individual data level in export.
>Maybe Sql loader is a better option for you. But then for that you will
>need to create 100 control files and that I think wont be a good idea.
>
>Another option that I can think of is this.
>
>1. Create views for each of those tables satisfying the condition. This
>can be achieved by using a plsql block.
>2. Export those views to the target schema and recreate tables based on
>those views alongwith the constraints required.
>
>I know it is a tedious process, but given your requirement I do not see
>any other way out.
>
>Vikas Bhat
>Senior Software Engineer,
>FBSI Pvt Ltd.,
>Embassy Golf Links Business Park,
>Intermediate Ring Road,
>Bangalore - 560071
>Email - vikas.[Email address protected]
>Ph:91-80-56916482
>Mob:91-9845589149
>Those who aspire for the light of sun; need to bear its heat.
>
>Any comments or statements made in this email are not necessarily those
>of Fidelity Business Services India Pvt. Ltd. or any of the Fidelity
>Investments group companies. The information transmitted is intended
>only for the person or entity to which it is addressed and may contain
>confidential and/or privileged material. If you have received this in
>error, please contact the sender and delete the material from any
>computer. All e-mails sent from or to Fidelity Business Services India
>Pvt. Ltd. may be subject to our monitoring procedures.
>
>
>
>-----Original Message-----
>From: Pradhan Prakash
>[mailto:oracledba-ezmlmshield-x37260149.[Email address protected]
>Sent: Wednesday, August 31, 2005 4:10 PM
>To: LazyDBA Discussion
>Subject: Export Help
>
>
>Hi Folks
>
>Need some help on Oracle export - i am using Oracle 8.1.5
>I am trying to export about 100 tables out of total 300 tables in a
>schema, depending on some of the values in the tables :
>for example : all the 100 tables have empno as a column and i want to
>export all 100 tables using a where clause saying where empno = '001'.
>Can i export using where clause ? Can i put this condition in a PAR file
>
>and then export ?
>
>Please help..
>
>Regards,
>Pradhan
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>
>
>--------
>website: http://www.LazyDBA.com
>Please don't reply to RTFM questions
>Oracle documentation is here: http://tahiti.oracle.com
>To unsubscribe: see http://www.lazydba.com/unsubscribe.html
>To subscribe: see http://www.lazydba.com
>By using this list you agree to these terms:http://www.lazydba.com/legal.html
>
>
>
>


Oracle LazyDBA home page