Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Need script to create database

Re: Need script to create database

From: Dale Benjamin <no_spam_admin_at_db3.com>
Date: 1997/09/11
Message-ID: <341876A0.4B08238D@db3.com>#1/1

Assuming you're running Oracle7, have you tried backing up the controlfile (use "alter database backup controlfile to trace;") and then using that generated trace file to create your database? We do that whenever we copy a database.
- dale benjamin

Johnny Verhoeven wrote:
>
> Does anybody has a sql script that will generate a create database
> statement based on the information in the catalog.
>
> Thanks
>
> Johnny.Verhoeven_at_club.innet.be
Received on Thu Sep 11 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US