Re: Create Database.

From: Greg Kainz <gregkainz_at_home.com>
Date: Sun, 31 Dec 2000 04:41:41 GMT
Message-ID: <9Oy36.102236$x6.45604743@news2.rdc2.tx.home.com>

Why the full import? We regularly recreated our finapps development database by taking a cold backup of PROD with "alter database backup controlfile to trace" and then "alter database rename....." to restore it in it's new location (after editing the filenames with the new locations)...

<vdolt_at_my-deja.com> wrote in message news:92ivln$qb$1_at_nnrp1.deja.com...
> I have an existing database and want to create another one just like
> it. Is there a way to reverse engineer "create database" statement into
> the script from an existing database? I want to include rollback
> segments, datafiles, redo logs and tablespaces (no user schemas) and
> then do a full import.
> Please let me know.
> Thanks.
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Sat Dec 30 2000 - 22:41:41 CST