Or....just export the entire schema, import into second database, then delete
the rows you dont need.

Stacy

On Wednesday 31 August 2005 6:52 am, 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

--
Stacy Gaddy
W-(919)321-0855
C-(910)376-1256
stacy.[Email address protected]

Oracle LazyDBA home page