RE: Selective export

From: Mercadante, Thomas F (LABOR) <"Mercadante,>
Date: Mon, 9 May 2011 08:20:11 -0400
Message-ID: <AD4532B304E00C4F9AEFA0D338DF7DD1EE145D28_at_excnysm95banp.nysemail.nyenet>



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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Abhishek Gurung Sent: Monday, May 09, 2011 6:17 AM
To: nigel.cl.thomas_at_googlemail.com; 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_at_googlemail.com
To: abhishek.gurung_at_hotmail.com
CC: oracle-l_at_freelists.org

(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_at_hotmail.com<mailto:abhishek.gurung_at_hotmail.com>> 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

--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 09 2011 - 07:20:11 CDT

Original text of this message