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
Oracle LazyDBA home page