CODEWITHSUNDEEP
oracle-sqldeveloper
Daniel
Daniel

Reputation: 5381

Linked Databases in SQL Developer

I'm using SQL Developer to host some data, but I think my configuration isn't right. Lets say I have a database named DB1 with the tables

DB1
-db1_name
-db1_cities

The problem is when I try to create a new database let say DB2, SQLdeveloper creates the database but it also includes all the tables from DB1 (db1_name,db1_cities). Also if I removed the tables from DB2, the tables also disappear from DB1. How can I change my configuration so this does not happen anymore and each database is independent from each other?

To create a new data base I usually go in the SQL Developer GUI interface to connections, then I click on new Connection and provide the connection name, user name, and password. I leave the connection type to basic and the role to default. The host name as local host, and the default port.

Upvotes: 0

Views: 162

Answers (1)

Arun
Arun

Reputation: 951

That's happening because you are currently adding a new database connection instead of creating a database.

To create a new database from scratch, take a look at this link, it'll take you through step by step on creating the new database.

Upvotes: 2

Related Questions