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
Im not going to physically do the migration, but I
want to make sure certain features are set up. Let me know if Im missing any of
the basics(anything that is a pain to add on my own later).
Locally Managed tablespaces are the default right?
Automatic Segment Allocation
Undo Tablespace
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
of 9i
databases around here right now and that stuff comes in kind of handy. :)
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Ryan
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 09, 2003
3:59 PM
To: Multiple recipients of list
ORACLE-L
Subject: question about migrating
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
11 matches
Mail list logo
