multitenant

How to run expdp in pluggable database(PDB)

In the multitenant database, For getting an export dump from the pluggable database, we need a follow a bit different process. DEMO: PLUGGABLE DATABASE(PDB) – PRE1 SCHEMA_NAME – DBACLASS (...

Perform Flashback in pluggable database(PDB) in oracle 12.2

In oracle 12.2 version, we can perform flashback at PDB level also.It has no dependency on container. EXAMPLE: Create a restore point at PDB level: [crayon-5beda6c9d31b7803080056/] Now before doing fl...

How to setup listener for PDBS in Multitenant database.

If you wish to setup listener for a particular PDB in the multitenant database, then follow as below. Create a listener and start it. [crayon-5beda6c9d352c826682398/] Now connect to the PDB for which ...

Common User vs Local User in 12c Multitenant

With oracle 12c Multitenant architecture, New terminologies for users has been introduced. LOCAL USER and COMMON USER. SEE ALSO: Oracle 12c Multitenant Architecture COMMON USER: 1.A common user is a D...

ORA-65049: creation of local user or role is not allowed in CDB$ROOT

PROBLEM: While creating a user in root container in the multitenant database, Got error ORA-65049.   SQL> show con_name CON_NAME —————————...

ORA-65096: invalid common user or role name

PROBLEM: While creating a user in root container multitenant database, got the below error. SQL> show con_name CON_NAME —————————- CDB$ROOT SQL...

Local/Shared Undo mode in oracle 12.2 multitenant database

There are two undo modes in oracle 12.2 Multitenant database 1. Local undo mode 2. Shared undo mode Local undo mode: In this mode, each container ( i.e PDB ) in multitenant will have their own active ...

Skip to toolbar