How to flashback a Pluggable database ( PDB) in oracle 12.2

From Oracle 12.2 onwards we can flashback a Pluggable database(PDB). And flashback is very easy and simple if LOCAL UNDO is enabled(which is also a new feature in Oracle 12.2). Let’s start the DEMO. DEMO: 1. Check whether local undo is enabled or not.

For more info – Local undo and shared undo in […]

How to create encrypted tablespace in PDB( oracle 12c)

For creating an encrypted tablespace in a PLUGGABLE DATABASE ( PDB) for multitenant oracle 12c setup, we need to do a few additional steps. DEMO: In the below DEMO, we will create a encrypted tablespace under a pluggable database SDCP1 1. Update sqlnet.ora file with ENCRYPTION_WALLET_LOCATION

2. Set encryption key at container DB:


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 ( this schema/user is present in PDB PRE1) 1. Make sure PDB service is registered in the listener.

2. Add the entry in tnsnames.ora file […]

Rollback database patch in oracle 12c

In this article , we will provide steps for rolling back a patch in non-rac standalone database. PATCH TO BE ROLLED BACK – 27105253 – Database Jan 2018 Release Update (DB RU)   1. Check the existence of patch in oracle home inventory.

2. Shutdown services running from oracle_home(database , listener)

3. […]

Apply patch on oracle 12.2 database ( Release update)

In this article , we will explain the steps for applying patch Database Jan 2018 Release Update (DB RU) on oracle 12.2 database. Beginning in July 2017, Oracle has transitioned to a more flexible and responsive strategy for the database software release process. These changes only affect Database and Grid Infrastructure release 12.2 or later. […]

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:

Now before doing flashback, we have to check whether what is the undo type, whether local undo or shared undo.

SEE ALSO – Local undo and shared undo […]


                TRUST_EXISTING_TABLE_PARTITIONS is a new option for the parameter data_option in the impdp utility of Oracle 12.2. Previously, If we are loading data to an existing partitioned table using impdp, then despite mentioning parallel option, partitions were getting loaded one by one, Which slowdown the import process.   […]


OUTBOUND_DBLINK_PROTOCOLS  specifies the network protocols allowed for communicating for outbound/outgoing database links in the database. It is introduced in Oracle 12.2 release. Possible values – { ALL | NONE | [ TCP | [, ] | TCPS | [, ] | IPC ] } By default, the value is set to ALL. i.e User can […]

ENABLE_PARALLEL_DML hint in oracle 12c

Till oracle 12c, For doing DML transactions in parallel, we need to enable PDML (parallel DML) at session level. I.e before any DML statement, we need to issue below statement.

In oracle 12c, it introduced a hint for parallel dml, ENABLE_PARALLEL_DML , which we can use directly inside the dml sql statement. No need […]

MAX_STRING_SIZE parameter in oracle 12c

This parameter was introduced in Oracle 12c. MAX_STRING_SIZE controls the maximum size of string size in Oracle database. Either we can set it to STANDARD or.EXTENDED The default value is STANDARD MAX_STRING_SIZE = STANDARD means the maximum size of strings is 4000 bytes for VARCHAR2 and NVARCHAR2 MAX_STRING_SIZE = EXTENDED means maximum size can be […]

Page 1 of 612345...Last »
Skip to toolbar