Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to create/drop a database from Java (via JDBC)?

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

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 20 Feb 2004 16:04:17 -0000
Message-ID: <40363002$0$10334$ed9e5944@reading.news.pipex.net>


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

> >>>>> "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 - 10:04:17 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US