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

Steffen Siebert wrote:

> 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 :)

Look up Transportable Tablespace.

/Hans Received on Mon Feb 23 2004 - 13:27:06 CST