Create first database in Oracle Database 11g Express

1143015 pts.
Tags:
Oracle 11g
Oracle Database
SQL
Recently, I installed Oracle Database 11g Express on my Windows 7 machine. Also, I installed Oracle SQL Developer too. Now, I'm looking to create a database with two tables, followed by using SQL Developer to add / query data. But when I opened Developer, it's asking me to make a new connection (I think it's saying that I already created a database but I didn't). How do I actually create my first database in Oracle 11g? Thanks!
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

The database is automatically created when you install the database software. 

In Oracle, the concept of database is different from what you might know from other systems, like MySQL.

During the installation, you were asked to define a password for the SYS account.  You have to use that username and password to create your first connection.

After you connect with the SYS user, you should create a “normal” user, and then connect using that normal user to create your tables and test queries.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: