Re: CREATE DATABASE using OCI, is it possible?

in article 6de30668.0203121252.1b5d8147_at_posting.google.com, rizzo2k_at_hotmail.com at rizzo2k_at_hotmail.com wrote on 3/12/02 12:52 PM:

Well - you could try CREATE SCHEMA - but I have to ask - why do you want to create a DB (or schema) on the fly ? Perhaps there is a better solution to the problem you are trying to solve

> hello,
>
> I'd like to be able to have an application create a database in the
> oracle server (8i) by using the OCI APIs. I'm starting to get the
> uncomfortable sense that this won't be possible. Needless to say, I'm
> fairly new to oracle.
>
> I've tried doing this thru sqlplus and running OCIStmtExecute() and
> have been getting the following:
>
> ORA-01501: CREATE DATABASE failed
> ORA-01100: database already mounted
>
>
>
> After a little digging, I've come to realize that my idea of a
> database and oracle's are a little different. However, is there
> something comparable to the SQL command "CREATE DATABASE myDB" using
> OCI or anything else for that matter.
> Anyway of creating a database thru an application...?
>
>
> Many Thanks,
>
>
> -Zo
Received on Wed Mar 13 2002 - 05:01:30 CET