Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to create/drop a database from Java (via JDBC)?
would you create a new sqlserver instance on a machine with no user
interaction? The same arguments apply
-- Niall Litchfield Oracle DBA Audit Commission UK "Steffen Siebert" <news_at_SteffenSiebert.de> wrote in message news:uy8qxzr7w.fsf_at_SteffenSiebert.de...Received on Fri Feb 20 2004 - 10:04:17 CST
> >>>>> "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
![]() |
![]() |