Re: full database import

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 29 Nov 2000 07:04:51 +0100
Message-ID: <9026og$5vh0k$5@ID-62141.news.dfncis.de>

"WWC" <pdxbq_at_yahoo.com> wrote in message news:Fj%U5.353842$4d.43906869_at_news02.optonline.net...
> Could someone tell me how to use export/import to clone a database? I know
> how to export a full datbase but don't know how to do a full database
> import. Do I need to create a new database first? What is the general
steps?
>
> Thanks.
>
>
> Wayne
>
>
>

imp username/password full=y log=<anyfile> buffer=<any high number> commit=y ignore=y.

And yes, you need to precreate the database, and you might want to precreate the tablespaces as well.
Before you create tablespaces you should have a rollback segment in the SYSTEM tablespace.

Hth,

Sybrand Bakker, Oracle DBA Received on Wed Nov 29 2000 - 00:04:51 CST