CODEWITHSUNDEEP
databaseoracle-databaseoracle11g
babybob
babybob

Reputation: 444

How to create a database in oracle 11g express edition?

I have installed Oracle 11g XE in my machine. Now I connecting it via System schema. How do I create a database of my own. Just like in MS SQL using

CREATE DATABASE database_name;

How do I create a database like this in oracle 11g XE.

Upvotes: 1

Views: 5134

Answers (1)

sstan
sstan

Reputation: 36523

Oracle is not like SQL Server. You don't get to create multiple databases (though things have changed since version 12, but it doesn't apply here anyways). With Oracle 11g XE, you only get one database instance called XE.

Instead, what you'll want to do is to create yourself a user within that XE database instance, which in effect results in an associated schema that you can use to create objects (tables, views, etc.) You can create more users (schemas) as needed.

For more detailed information: Database Express Edition Getting Started Guide

Upvotes: 4

Related Questions