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: Galen Boyer <galenboyer_at_hotpop.com>
Date: 20 Feb 2004 08:39:01 -0600
Message-ID: <ullmxrf7c.fsf@standardandpoors.com>


On 20 Feb 2004, news_at_SteffenSiebert.de wrote:

>>>>>> "HF" == Hans Forbrich <hforbric_at_yahoo.net> writes:

> But I'm still not convinced that a schema is all we
> want/need. Are all tables in one schema stored in files
> separate from tables of other schemas so I can transfer my
> schema "xy" only via a bunch of files from one oracle server to
> another? Can I create backups of schemas? I'm afraid such
> things are only possible with complete databases and thus I
> really need to create databases not only schemas :)
>
> HF> And yes - what you want CAN be done easily in Java!
>
> Creating schemas? With your sql statements it seems
> easy. Creating databases? I still have no clue.

From what you are saying, where you are going to author a production application that creates tables and also is able to move those objects around, you really need to read the Oracle concepts manual. You will need to understand how Oracle sees the operating system if you want to be successful. If you rely on this forum for that information, you will fail. We will only be able to help you past particular issues, not explain the entire thing.

-- 
Galen Boyer
Received on Fri Feb 20 2004 - 08:39:01 CST

Original text of this message

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