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

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

    HF> Hopefully you are starting to understand that RDBMS
    HF> terminology is overloaded and things like Database do not mean
    HF> the same thing in Oracle vs SQLServer.

and

    HF> A DATABASE is the complete collection of **files** - logs,
    HF> control files, tablespace files, and so on, as well as the
    HF> system dictionary.

This seems not very different to SQLServer. If I create a new database, several files are created (for data, transaction log etc.)

Thanks for the sql templates.

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.

Ciao,
  Steffen Received on Fri Feb 20 2004 - 06:31:04 CST