How to create a new database after initally installing oracle database 11g Express Edition?

oracle oracle11g oracle-sqldeveloper oracle-xe
Zo72 picture Zo72 · Mar 2, 2012 · Viewed 365.6k times · Source

I have installed Oracle Database 11g Express Edition on my pc (windows 7) and I have installed Oracle SQL Developer as well.

I want to create a simple database to start with, maybe with one table or two and then use Oracle SQL Developer to insert data and query it.

When I open Oracle SQL Developer, it asks me to create a new connection, therefore it assumes that a database has already been created.

So my question is, how do I create an initial database in Oracle 11g?

Answer

Albert T. Wong picture Albert T. Wong · Dec 24, 2012

When you installed XE.... it automatically created a database called "XE". You can use your login "system" and password that you set to login.

Key info

server: (you defined)
port: 1521
database: XE
username: system
password: (you defined)

Also Oracle is being difficult and not telling you easily create another database. You have to use SQL or another tool to create more database besides "XE".

Related questions

Explicitly set column value to null SQL Developer

I am new to Oracle DB and I am using Oracle SQL Developer (Ver 3.0.02) to query the DB. I wanted to explicitly set one column to null? How do I do that in the SQL Developer GUI? Previously in MSSQL, …

Read More
How to increase buffer size in Oracle SQL Developer to view all records?

How to increase buffer size in Oracle SQL Developer to view all records (there seems to be a certain limit set at default)? Any screen shots and/or tips will be very helpful.

Read More
Extract number from string with Oracle function

I need to create an Oracle DB function that takes a string as parameter. The string contains letters and numbers. I need to extract all the numbers from this string. For example, if I have a string like RO1234, I …

Read More