Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 356
  • Last Modified:

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?
0
pointeman
Asked:
pointeman
3 Solutions
 
DavidSenior 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 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
 
Wasim Akram ShaikCommented:
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
 
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.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Geert GruwezOracle 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)
0
 
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.
0
 
Geert GruwezOracle dbaCommented:
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
 
pointemanAuthor Commented:
thx everyone
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now