Oracle SQL Developer Newbie Tip Needed?

So I thought I would try the free Oracle Express and SQL Developer edition. I downloaded and successfully installed both products. I see how to add a new 'Connection', but not easily how to simply add a new database within the GUI. Seems like I need to use a command-line. I think MSSQL SQL Studio is much more intuitive.

Q. Would someone help me get started building a new database and tables using the Oracle SQL Developer GUI?
Who is Participating?
DavidConnect With a Mentor Senior Oracle Database AdministratorCommented:
Yes, you need to have a database (up and available) in order to test the client connection (over SQL*Net).  SQL*Developer has a good number of tutorials at, and also many prior references searchable here at E-E.  A "basic" connection requires you to provide the host, the TCP/IP port number, and the name of the database, such as orcl.  

If you don't have a database to connect to, rather than creating a new one the recommended approach is to download and install one of the free versions from Oracle, such as the personal one.  They all come with a default user account (SCOTT/TIGER) and several schemas (HR) that are pre-loaded.  is the place to start.
Wasim Akram ShaikConnect With a Mentor Commented:
also, if you want to go directly on tutorials of how to create table and table structures or db objects in sql developer you can refer to

also refer to this link on how to get started on using the oracle sql developer
pointemanAuthor Commented:
Thx forthe links although I've read them already, hence my posting here trying to make sense of why I cannot simply build a new database. I see why most people are using TOAD for Oracle. Thanks for your help.
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Geert GOracle dbaCommented:
when using the express edition your database will be named XE
have you tried connecting using XE as database, port 1521 and your ip for connecting ?

otherwise look in the (oracle)\bin folder for dbca (Database configuration assistant)
pointemanAuthor Commented:
Yes, followed the 'new connection' setup instructions as:
Username: system
Password: my install password
SID: xe

Q. Are you saying that I can only use 1database at a time?

It seems apparent I cannot easily create a new database.
Geert GConnect With a Mentor Oracle dbaCommented:
you can install only 1 XE database on 1 computer

check the restrictions:
pointemanAuthor Commented:
thx everyone
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.