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 -> Solution found!?! Was: How to create/drop a database from Java (via JDBC)?

Solution found!?! Was: How to create/drop a database from Java (via JDBC)?

From: Steffen Siebert <news_at_SteffenSiebert.de>
Date: 23 Feb 2004 19:57:07 +0100
Message-ID: <usmh1wrng.fsf@SteffenSiebert.de>


Hi,

first of all I've found the ultimate answer on how to find out what I really want to create/drop, making debates on different names between RDBMS obsolete:

It's the thing which is selected in the JDBC connection string!

And since it's for orcacle the sid, creating databases _is_ the right thing :)

But I've also read more oracle documentation as advised, and came to the conclusion, if creating databases is too hard / not advised, creating tablespace is the second best solution. It can be created and dropped by simple SQL statements, contains all data and according to the docs the tablespace file can also saved for backups or transfered to another oracle database.

And since I can bind the tablespace as a default to a user, the tablespace can be selected by the username used for the JDBC connection (which is a bit ugly, but seems to work).

Now I only need to know how I "disconnect" a tablespace file from one database and "reconnect" it to another one. I'm sure the answer is somewhere in the oracle docs, but I don't know where. So any hints are appreciated :)

Ciao,
  Steffen Received on Mon Feb 23 2004 - 12:57:07 CST

Original text of this message

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