ORACLE 12C

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) 12.2.0.1.180116   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 in oracle 12.2 datapump

                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 in oracle 12.2

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 […]

Row limiting clause in oracle 12c

 Row limiting clause clause allows sql queries to limit the number of rows returned and to specify a starting row for the return set. 1. Fetch first N rows:

2. Fetch 5 rows after offset of 4 rows

3. Fetch percentage of rows from a query:

IN-MEMORY in oracle 12c

Introduction: Oracle in-memory concept has been introduced in oracle 12c. This feature enables tables, partitions, materialized views be stored in memory using column format, which delivers fast SQL processing for the Analytical purpose. To understand Database In-Memory feature and its benefits we first need to understand the unique “dual format” architecture that enables Oracle Database […]

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