Re: imp whole database

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 11 Jul 2002 17:28:24 +1000
Message-ID: <NlaX8.32789$Hj3.98420@newsfeeds.bigpond.com>

Hi Xueyang,

Yes it can be done.

If you're new to export/import utilities, I suggest a good read of the Oracle Utilities Manual.

exp help=y command and imp help=y command will display your options.

New users find the interactive method easiest, Just type 'exp' to export and 'imp' to import and follow the prompts.

The following *basic* commands will do the trick.

>exp user/password full=y file=fullexport.dmp

>imp user/password full=y file=fullexport.dmp

Make sure user has exp_full_database and imp_full_database roles. Make sure Oracle_Sid or an appropriate service name is used for each database.

First step though, a good read of the doco.

Good Luck

Richard
"xueyang" <xueyangy_at_singnet.com.sg> wrote in message news:agjass$gi8$1_at_reader01.singnet.com.sg...
> Hi,
>
> I want to exp whole DB from 9.0.1 and imp it to 9.2.0. Can it be done? if
> so, anybody has any idea for me?
>
> Thansks in advance
>
>
Received on Thu Jul 11 2002 - 02:28:24 CDT