About oracle database and instance, can I create database in XE edition? -
i think, oracle instance serial of os process, , oracle database set of database files.
and oracle instance can mount database linux can mount disks.
so, in xe cannot run 2 instances, can create multiple databases , use instance mount , unmount.
but after reading this thread, i'm confused.
you can have 1 xe 'database' or 'sid', can have multiple schemas.
no. can have 1 xe database per server. can have many schemas in database you'd like. if coming background in other databases, databases refer database equivalent oracle refers schema.
see similar stack overflow question:
can have multiple databases on oracle express edition
oracle xe has following hardware limitations:
- only use 1 cpu on system
- use 1gb of ram
- store 4gb of data, 11gb of data on 11.2
Comments
Post a Comment