Some simple options:
- The 9.x installer still gives the option of
creating scripts in the old fashioned way. The key is
not to choose a "template" database. A little
scrubbing and they work fine...but man do they take a
while to create a db nowadays.
- My preferred option is to create a skeleton db with
just system/undo/temp/pfile (using the installer or
otherwise) and get everything just right. Then zip it
up with the text of a "create controlfile" and voila!
You have a db ready to go - whenever you need a new
one, you just unzip, hack the controlfile to rename it
and bingo...super quick and be definition, all your
databases have the same basic starting point
hth
connor
- Jeremy Pulcifer <Jeremy.Pulcifer_at_kadiri.com>
wrote: > ...since 8.1.7. I've always ran the database
> creation utility, then swiped
> the scripts outta the admin\[sid]\create\ directory,
> scrubbed 'em a bit, and
> let er rip. My consultants create/install new db's
> quite frequently, and the
> 8.1.7 *.bat's work quite well for 'em.
>
> However, as I'm sure you've all figgered out
> already, this don't work no mo.
> I've taken some cursory rambles thru orafaq, but
> came out more confused than
> I came in. I don't want to rely on installing perl
> or Oracle DCA on each
> machine, as the consultants I'm supporting aren't
> going to be too keen on
> having to go from their current "hit the .bat and
> wait til it says all done"
> MO.
>
> So, I'm sure a solution or twenty has been put
> together for NT/Windows. Care
> to share? I'm sure I could re-invent this particular
> wheel, but my boss
> keeps hollering at me for stuff that I'm actually
> supposed to produce, so
> If'n I can turn this one around in a reasonable
> time, I'd be much abliged.
>
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Dec 03 2002 - 04:48:47 CST