Re: dbassist vs create database ?

In article <398ECBA9.8593745A_at_SPAMwillowglen.ab.ca>,   Brad Lotsberg <lotsberg_at_willowglen.ab.ca> wrote:
> Oracle 8i 8.1.5 on Sun sparc Solaris ...
>
> I had a look at the scripts generated by dbassist (save commands to
> script instead of create database now option) and they seem to do a
 lot
> more than what a 'create database' sql command does. In particular I
 am
> wondering about the several other scripts that are run to create the
> system tables and views. These other scripts are not mentioned in the
> sql documentation for 'create database'. What happens if you do use
> 'create database', but don't run these scripts? Do you get a database
> with no system tables? If so, is the database useable? Also, who
> creates files like init<sid>.ora, etc?
>
> I am writing a Sybase->Oracle conversion utility to suit my needs
 using
> the OCI. It is basically done and works well, however it currently
> requires an empty Oracle database to exist already. I would like to
> include the creation of the database in my application, but I'm not
 sure
> how well one can reproduce what dbassist does just by issuing sql
> statements via the OCI.
>
> Any thoughts on this matter are appreciated.
>
> Brad Lotsberg, EET.
>
> lotsbergNO_at_SPAM.willowglen.ab.ca (remove NO SPAM to reply of course)
>
>

Personal opinion - Write scripts to do all instance creates. The dbassistant is ok for novices and very very small non-production databases. You will end up needing (or you should) check all parms and options anyway, so why not have a temple script to create your databases that encorporates all your standards and learning.

I find 'helfulware' to end up costing me more time that it saves me in the long run. I would NEVER use it for a production database.

Again - Just my opinion :-)

--
Doug Coan
Oracle Certified Professional DBA


Sent via Deja.com http://www.deja.com/
Before you buy.