RE: Selective export

Hi

Thanks for your reply. 
What I want is like this
I need selected data from three tables not whole tables e.g
select * from emp where empid = 1
select * from dept where deptid = 2
select * from countries where countryid = 3

Regards
Abhishek
Date: Mon, 9 May 2011 08:09:45 +0100
Subject: Re: Selective export
From: nigel.cl.thomas@xxxxxxxxxxxxxx
To: abhishek.gurung@xxxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx

(Taken from http://wiki.oracle.com/page/Oracle+export+and+import+)

To export specific tables to disk:

- Login to server which has an Oracle client

  exp SYSTEM/password FILE=expdat.dmp TABLES=(scott.emp,hr.countries) -the 
above command uses two users : scott and hr   

  exp <user>/<password> FILE=scott.dmp TABLES=(emp,dept) the above is only for 
one user   


Note that in first case user doesn't have to be SYSTEM, but does need access to 
the tables being exported.

HTH Nigel

On 9 May 2011 07:50, Abhishek Gurung <abhishek.gurung@xxxxxxxxxxx> wrote:






Hi

I want to export selective data from three tables in one dump.
Can anyone suggest me how it can be done?
If it is not possible can I combine the three dump files into one?

Thankyou.

Regards

Abhishek

Other related posts: