Exclude Generated Objects – SQL Developer

The term database has a different meaning in Oracle. The definition of database by Oracle:

A set of files, located on disk, that store data. Because a database instance and a database are so closely connected, the term Oracle database is often used to refer to both instance and database.

Oracle Database Architecture

If you wanted to seperate data per application, you could do that by using seperate tablespaces and schemas.

Creating such a database is a complex process, and it is done with DBCA or SQL*Plus on the database server, not with a remote connection:

Creating and Configuring an Oracle Database

In 12c, the multitenant architechture was introduced, that is similar to the concept in SQL Server.

Overview of Managing a Multitenant Environment

If you have a container database, there you can easily create new pluggable databases from SQL Developer, when using a DBA connection.

Managing Pluggable Databases (PDBs) using Oracle SQL Developer

First of all check whether your pluggable database is opened or not.

SQL> select name, open_mode from v$pdbs where name='PDBORCL';

If it is in mounted mode then,

SQL> alter pluggable database pdborcl open;

Now on SQL Developer Create new connection as,

Connection Name: demo-pdborcl

Username: demo

Password: *****

Connection Type: Basic(If you wish to use TNS connection type you have to create TNS Network Alias in client side.)

Hostname: ip/dns

Port: 1521

SID: (If you use SID like 'ORCL' you will be connected to root container, therefore use Service name instead of SID)

Service name: (You can get your pdb's service name by firing $ lsnrctl serivce, also you can use USE_SID_AS_SERVICE_listener parameter on $ORACLE_HOME/network/admin/listner.ora file as USE_SID_AS_SERVICE_listener=on and any given SID will be treated as service name.

Some useful links-