Re: exporting and importing

From: <alistair.thomson_at_sphinxcst.co.uk>
Date: Fri, 15 Dec 2000 17:23:13 GMT
Message-ID: <91dk1n$6ov$1@nnrp1.deja.com>

Set the environment for 8.1.5 sid

c:\> set local=your_oracle_sid_name
c:\> exp system/manager_at_tns_service_name file=exp.dmp full=y log=exp.log buffer=2000000

set the environment for 8.1.6 sid

c:\> set local=your_oracle_sid_name
c:\> imp system/manager_at_tns_service_name file=exp.dmp full=y log=imp.log buffer=2000000

Hope it helps.

In article <B3p_5.99199$Z2.1153220_at_nnrp1.uunet.ca>, "Choung Chao" <cchao_at_pmc.ca> wrote:
> Hi,
>
> How do I export my full database from v 8.1.5 and import it into
Oracle
> 8.1.6 on the same server. I'm using WindowsNT. I want to know how
to do
> this at the DOS prompt.
>
> thanks,
>
> Choung
>
>

Sent via Deja.com
http://www.deja.com/ Received on Fri Dec 15 2000 - 11:23:13 CST