CODEWITHSUNDEEP
sqldatabaseoracle-databaseconnection
NYannickske
NYannickske

Reputation: 131

Set up own database in SQL Developer

I'm trying to make a new connection in Oracle SQL Developer, but instead of connecting to a existing database I want to make a new database where I can upload my own tables into. I know this is possible, because someone has done it on my other pc.

Trying to do 'new connection' always says that the network adapter could not make the connection. That is logical, because I want my own that I can use only on my pc.

Anyone knows how to accomplish this? Thanks in advance!

Grtz!

Upvotes: 3

Views: 11712

Answers (2)

Tim Sanders
Tim Sanders

Reputation: 851

The CREATE DATABASE [databasename] command will create a new database. Make sure you're connected to the server that you want to create the database on.

CREATE DATABASE mydatabase;

You may need to supply more options depending on the configuration of the server. Also,

"To create a database, you must have the SYSDBA system privilege."

http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_5004.htm

Upvotes: 3

RMAN Express
RMAN Express

Reputation: 496

You cannot do this with SQL Developer.

Do you have a running database on your PC already? Is it Express Edition (XE)? Express Edition can only have one database. If it is not XE, use DBCA ( Database Configuration Assistant ) to create the database.

If you do not have Oracle on your PC, then you need to download and install the binaries. XE install creates the database during install. Other versions of Oracle will prompt you if you want a database or use DBCA after the binaries are installed.

Are you sure you want a database and not just a new user/schema to store your tables? See docs for "CREATE USER ..." command to create a new user in an existing database.

Upvotes: 3

Related Questions