Create Database Script for 8.17

[Michael42]

Hello,

Would someone mind posting a database creation script for Oracle 8.17 that you use regularly in a production environment?

I am trying to get up to speed and get real world sense of the base requirements as opposed to book theory.

Any comments on how you evolved to using this script would be great.


Thanks very much for your time,

Michael42

 

[ofsouto]

Hi, Michael

Did you get the script?
Could you send me a copy?

Thank you very much.

O. F. Souto

 

[sem]

I really doubt that this script may exist


Regards, Dima

http://seminihin.narod.ru

 

[THoey]

It probably doesn't exist as each database creation should be different and distinct.

Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[SantaMufasa]

Michael,

I agree with Terry, that "each database creation should be different and distinct," but given that, I HIGHLY recommend that you develop your own "boilerplate" database build script, which you then tailor with the slight changes that may be necessary for each build.

I have such boilerplate (one for each dissimilar operating system such as one for Windows, one for Unix, et cetera). I can share a sample boilerplate with you...you choose either Windows or Unix...and let me know. You should, however, be familiar enough with the code to know what modifications are appropriate for your environment.

(I must leave for an appointment in a couple of hours, so, depending upon your response and my availability, I'll get it to you as soon as I can.)

Mufasa
(aka Dave of Sandy, Utah, USA @ 19:16 (06Jan04) GMT, 12:16 (06Jan04) Mountain Time)

 

[sbix]

Hi muf, you're really playing Santa's role today

 

[Michael42]

Thanks all for your comments - they were very useful.

Thanks,

Michael42

 

[mrmac228]

You could run dbassist and let that create a basic script for you.

Something is better than nothing - or is it?

I love deadlines. I like the whooshing sound they make as they fly by - Douglas Adams

 

[KenCunningham]

Santa - I'd appreciate a copy of your boilerplate script for Unix if possible, please. Can you email it to kencunningham1957@yahoo.co.uk . Might I also suggest it be added as a FAQ here. Cheers and best (if belated) New Year wishes.