Re: Script for creating a production database from scratch.

bogus wrote:

> Hello everybody,
>
> I am new to Database Administration.
>
> Can someone please mail or post the database creation script for a
>
> production database.
>
> It will be very helpful if you send me a script which is presently
>
> in use for a production database. I will greatly appriciate for that.
>
> Thanks
> Kishore Putta
> E-mail: Kishore.putta_at_usm.edu

Hi boggy

my two cents worth.

If you're running 7.3 the creation scripts for the demo database are in orant\database called buildall.sql, scott.sql or something like that. Just have a look for the .sql files in this directory and you should be able to follow them ok. A better way might be to use the default database that's created and modify it.

Have fun...

Jeremy CopeAuckland NZ Received on Mon Jul 07 1997 - 00:00:00 CDT