Re: Selective export
From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Mon, 9 May 2011 08:09:45 +0100
Message-ID: <BANLkTi=uq0X_JLmyfa5Dhy6ucTQyHwUjyg_at_mail.gmail.com>
(Taken from http://wiki.oracle.com/page/Oracle+export+and+import+)
Date: Mon, 9 May 2011 08:09:45 +0100
Message-ID: <BANLkTi=uq0X_JLmyfa5Dhy6ucTQyHwUjyg_at_mail.gmail.com>
(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> 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-lReceived on Mon May 09 2011 - 02:09:45 CDT