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

>>>>> "NL" == Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> writes:

    NL> I suspect that you *can* do it, there is after all a CREATE
    NL> DATABASE statement and a set of steps to be followed including
    NL> the os stuff. You really, really,really don't want to do it,
    NL> and if you go to an oracle shop will most probably not be
    NL> *allowed* to do it - certainly I'd question the competence of
    NL> those who allowed it to be done like this. It will also take
    NL> several hours to complete in all likelihood.

I'm still puzzled why creating a database seems such a taboo here. In fact, there is a tool/wizard call dbca (which is written in java) coming with oracle 9i which enables me without any oracle knowledge to create a database with a few mouse clicks (and also to drop it again). I've done it, it takes only some minutes and after that verything is working for us (we can create tables and run our application).

All I want to do is the same as dbca but without user interaction (mouse clicks) from my own java application.

I'm aware that such a database only uses default settings which are not optimal in performance and it needs oracle experts to fine-tune the settings, but this is nothing I want nor need to do.

Ciao,
  Steffen Received on Fri Feb 20 2004 - 09:49:07 CST