Re: How to create/drop a database from Java (via JDBC)?

"Steffen Siebert" <news_at_SteffenSiebert.de> wrote in message news:ufzd621lh.fsf_at_SteffenSiebert.de...
> >>>>> "HF" == Hans Forbrich <hforbric_at_yahoo.net> writes:
>
> HF> I highly suspect you are confused about the term 'Database'.
> HF> Oracle uses it to define the complete set of files related to
> HF> their RDBMS.
>
> HF> Many others, espcially those who have experience with SQL
> HF> Server, Access, FoxPro and the like use the term database to
> HF> mean something similar to an Oracle SCHEMA.
>
> HF> If you want to be able to create one of more tables, you
> HF> likely want to learn about schemas. And DDL.
>
> No, I really need to create a database. Creating tables afterwards is
> no problem, but to create the initial database via application (java)
> seems to be tough with oracle. But since we were able to implement our
> program for MS SQL, Postgres and SAPDB, I'm still hoping that also
> Oracle can be tackled.
>
> HF> If you want to create complete Oracle databases, you are
> HF> likely going to be facing your own worst nightmare. Those of
> HF> us who want to retain sanity tend toward using DBCA (or manual
> HF> scripts like those created by DBCA).
>
> We can't use dbca since the database creation should be part of a
> unattended setup. I wasn't able to create a sql script with dbca, is
> the script pure sql which could be executed via jdbc?
>
> By the way, since dbca seems to be written in java, is there a
> documented java api used by dbca which can be used by java developers
> for their own programs too?
>
> HF> You may also want to spend some time looking in Oracle's
> HF> extensive docco for Application Developers - it's available as
> HF> part of the database documentation for your database version,
> HF> at http://docs.oracle.com. While you are there, consider
> HF> browsing around the Concepts manual - it's worth reading
> HF> several times.
>
> The problem of the oracle documentation is that I can't read all of it
> and it's hard to find out where the knowledge is hidden which I need
> to solve my problem. Thus my call for help here :)
>
> Ciao,
> Steffen

Heres an idea - run dbca once - you can save the scipts at the end, then you can see what these scripts do and copy the commands Received on Thu Feb 19 2004 - 15:47:08 CST