Hi!
Yes, the problem with own scipts was, that they tended go get old,
especially when the same Oracle7 scripts were used for creating 8i
databases etc..
Novadays there's lot more to do than just run create, catalog catproc to
create a full blown database.
Tanel.
- Original Message -
Tanel,
Thanks. By the way congrat for becoming an OCM
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Thu, 11 Sep 2003 03:19:24 -0800
Hi!
Yes, the problem with own scipts was, that they tended go get old,
especially when the same
I was told by one Oracle instructor that new features of 9i, including
Oracle Managed Files, could allow you to create a viable production database
by simply typing CREATE DATABASE -- once the init.ora (SPFILE?) was
created and the hardware layed out properly.
Perhaps not something many will use,
Hi!
Actually you can issue just create database with non-OMF configuration in
9i as well. The command creates files like log1orcl.ora, log2orcl.ora,
dbsorcl.ora, und1orcl.ora under $OH/dbs (or $OH/database as I tested on
windows with 9.2.0.4).
Tanel.
- Original Message -
To: Multiple
Dennis,
There is an option to just create a script for you based on your critaria
and then you can modify it according to your requirement before creating the
database. I think I used this almost 1 year back so don't remember exactly
at what stage it ask for this option...
Regards
Rafiq
Dennis and Rafiq,
When you use the dbca you are prompted for this option at the end i.e. create
scripts or create the DB. I HIGHLY recommend you go with the 'create script'
option as this allows you to QA the Oracle Intelligence before kicking it off.
It also serves as a good tutorial on what is
Faan,
Thanks. After auto creation of script I changed it according to our own
requirement and it is a really nice features. The other databases we added
afterword we used the same scripts adter some changes.
No need to keep our own scripts all the time.
Regards
Rafiq
Reply-To: [EMAIL
Ryan
If you (or whoever) is using dbca, I believe all this is configured
automatically. But watch the block size. That is the only thing you can't
change later.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, September
Little tidbits I kind of like is setting a
default temporary tablespace and setting it in the
create database statement. You can also change the sys and system passwords in
the create database statement. Plus, you can create the undo tablespace there too.
I seem to be creating a lot of
Ryan
dbca is indeed available with Solaris. I used it today in fact. What I've
learned about it is:
- It runs in X-Windows. I don't have much expertise with X-Windows, but it
seems to run fine from the Solaris console.
- Unable to create a block size greater than 8k, at least what I've
10 matches
Mail list logo