Re: dbassist vs create database ?

Hi Brad,

Brad Lotsberg 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.
>

I found the generated SQL scripts quite useful (8.1.5 under Linux, should be very similar to the Solaris version). In my opinion a naked database out tof the "CREATE DATABSE" statement is almost unusable, since it lacks all the DD views, PL/SQL support...)

You could perhaps skip the execution of the last script. I think it has a lot to do with Java and CORBA within the database kernel.

Best regards!

Uwe

-- 
Uwe Schneider - WEB.DE AG - Amalienbadstr. 41 - 76227 Karlsruhe 
Forschung & Entwicklung - Tel. (+49) 721 94329 832
"In a world without walls and fences, who needs windows and gates?"