This content has been marked as final. Show 6 replies
Hello,1 person found this helpful
in Oracle one Database contains several user/schematas which contains the table/data.
In Oracle XE the default database name is XE. So the database is already created.
Hope this helps
Oh Ok, but then I can create another database than "XE"?? or not?? or just create a new user already will I have a new scheme??
look in the Oracle "Database Express Edition Installation Guide" (put it in google) there you will find all restrictions.
Oracle XE can have only one Intance (database)
PS: Sorry you can install Standard Edt. or Enterprise Edt. which can have more instances/databases.
Edited by: phaeus on 02.10.2012 00:11
Ok, thank you very much :)
you can create new database in XE but you have to create it manually by running create database statement. DBCA is not available in XE.
Ref : http://mohamedazar.com/2011/05/22/can-we-create-additional-database-for-oracle-express-edition/
Sure but you break the license, or forgive me and a did a mistake
3.2 Oracle Database XE Installation and Execution Restrictions
On a single computer, only one installation of the Oracle Database XE software can be performed. This does not affect any existing installation or new installations of Oracle Database 10 g Standard Edition, Oracle Database 10 g Standard Edition One, or Oracle Database 10 g Enterprise Edition. In addition, users can run only one instance of the Oracle Database XE database on each individual computer. To run more than one Oracle Database server instance or install more than one copy of the database software, upgrade to Oracle Database 10 g Standard Edition, Oracle Database 10 g Standard Edition One, or Oracle Database 10 g Enterprise Edition.