OracleConnections

Oracle Community Network

Creating new database under Oracle XE on Ubuntu

I've just installed Oracle XE in Ubuntu. Is there any way to create new databases, besides the one that comes with the installation, preferably from the command line so that I can do it from a script? It would be nice to have multiple databases started in the same time, if possible.

If it is not possible to create new databases, then maybe there is a way to "clean up" the default database? What I need is to be able to "start over" at any time with a fresh database.

I don't have experience with Oracle administration, so any hints, links, suggestions are welcome.

Thanks.

1 member likes this

▶ Reply to This

Replies to This Discussion

Permalink Reply by Joesph Moffit on August 23, 2013 at 2:19pm

In Oracle, a database means a collection of data files and control files stored on disk. You can have only one database with Oracle XE. A database is mounted by a Oracle instance, which means all the background daemons and programs that you can see with ps.

You probably want a schema, which is what other DBMS products (e.g. MySQL) often refer to as a "database". IIRC there was no limit on the number of schemas in Oracle XE. You can create those from the APEX UI that comes with XE, or from command line (with CREATE USER -- again, confusingly, a userand schema are largely synonymous in this case).