Solved

Oracle SQL Developer Newbie Tip Needed?

Posted on 2012-04-01
7
346 Views
Last Modified: 2012-04-10
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?
0
Comment
Question by:pointeman
7 Comments
 
LVL 23

Accepted Solution

by:
David earned 100 total points
ID: 37793674
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 docs.oracle.com, 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.

http://docs.oracle.com  is the place to start.
0
 
LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 100 total points
ID: 37793743
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

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/sqldev/r30/sqldev3.0_GS/sqldev3.0_GS.htm

also refer to this link on how to get started on using the oracle sql developer

http://www.oracle.com/technetwork/developer-tools/sql-developer/getting-started-155046.html
0
 

Author Comment

by:pointeman
ID: 37794101
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.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 37794703
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)
0
 

Author Comment

by:pointeman
ID: 37795468
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.
0
 
LVL 37

Assisted Solution

by:Geert Gruwez
Geert Gruwez earned 100 total points
ID: 37795513
you can install only 1 XE database on 1 computer

check the restrictions:
http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#BABIECJA
0
 

Author Closing Comment

by:pointeman
ID: 37828658
thx everyone
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question