RE: Selective export
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxx>
- To: "abhishek.gurung@xxxxxxxxxxx" <abhishek.gurung@xxxxxxxxxxx>
- Date: Mon, 9 May 2011 08:20:11 -0400
Abhishek,
Or you can do the following:
Create table temp_emp as select * from emp where empid=1;
Create table temp_dept as select * from dept where deptid = 2;
create table temp_countries as select * from countries where countryid = 3;
And then export/import the three temp tables. This works fine unless you are
exporting gigs of data.
HTH.
Tom
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Abhishek Gurung
Sent: Monday, May 09, 2011 6:17 AM
To: nigel.cl.thomas@xxxxxxxxxxxxxx; Oracle Freelist
Subject: 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<mailto: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:
