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 found.
I believe the reason is that dbca doesn't "create" the data files, but has
precreated files it just copies into place. That's my theory anyway.
  - All data files are created with autoextend on. But you can change that
later.
  - The database is created with spfile which I don't like but it is easy
enough to CREATE PFILE FROM SPFILE.
  - I am usually a skeptic of GUI tools, but I am really impressed with this
tool.
One alternative you could suggest to your production people is for them to
use dbca on a test system to create a database close to the one you want.
Then issue an ALTER DATABASE BACKUP CONTROLFILE TO TRACE. It creates a great
script (two versions in one, actually) that you can review, edit, etc. This
is an easy way to implement the 9i features you list without studying the
manual for the syntax  for each feature.
  Good luck, we production DBAs can be a touchy lot.

Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED] 


-----Original Message-----
Sent: Tuesday, September 09, 2003 5:55 PM
To: Multiple recipients of list ORACLE-L


they are doing it by hand i believe. no dbca. its a solaris system. dont
think there is a dbca for solaris? Im not a production dba, so i dont know
for certain,.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, September 09, 2003 6:14 PM


> 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 09, 2003 4:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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
> SPFILE
>
> any other goodies Im forgetting? Just basic settings. rest I can do
myself.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
>   INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ryan
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

Reply via email to