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

Steffen Siebert wrote:
> Hi,
>
> I'm new to oracle and have to implement a java tool using JDBC to
> create and drop a oracle 9i database (finally it should work on all
> platforms, but linux is the main platform).
>
> I've found documentation on the "create database" statement, but with
> its many parameters it's very confusing. And I even don't know which
> user/password combination is allowed to execute this statement.

I highly suspect you are confused about the term 'Database'. Oracle uses it to define the complete set of files related to their RDBMS.

Many others, espcially those who have experience with SQL Server, Access, FoxPro and the like use the term database to mean something similar to an Oracle SCHEMA.

If you want to be able to create one of more tables, you likely want to learn about schemas. And DDL.

If you want to create complete Oracle databases, you are likely going to be facing your own worst nightmare. Those of us who want to retain sanity tend toward using DBCA (or manual scripts like those created by DBCA). You may also want to spend some time looking in Oracle's extensive docco for Application Developers - it's available as part of the database documentation for your database version, at http://docs.oracle.com. While you are there, consider browsing around the Concepts manual - it's worth reading several times.

HTH
/Hans Received on Thu Feb 19 2004 - 13:54:22 CST