CODEWITHSUNDEEP
databaseoracle-database
lovespring
lovespring

Reputation: 19559

About oracle database and instance, can I create database in XE edition?

I think, that the oracle instance is just a serial of OS process, and a oracle database is a set of database files.

And a oracle instance can MOUNT database just like Linux can mount disks.

So, in XE we cannot run two instances, but we can create multiple databases and use the only instance to mount and unmount.

But after reading this thread, I'm confused.

Upvotes: 0

Views: 263

Answers (1)

GoldenJam
GoldenJam

Reputation: 1500

You can only have one XE 'database' or 'SID', but you can have multiple schemas.

No. You can only have one XE database per server. You can have as many schemas in that database as you'd like. If you are coming from a background in other databases, what most databases refer to as a database is most equivalent to what Oracle refers to as a schema.

See this similar stack overflow question:

Can I have multiple databases on oracle express edition

Oracle XE is also has the following hardware limitations:

  • only use one CPU on a system
  • use up to 1GB of RAM
  • store up to 4GB of data, 11GB of data on 11.2

Upvotes: 2

Related Questions