oracle 12.2.

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: SQL> alter session set container=HEPDB1; SQL> ...

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...

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 &#8...

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 ...

Split partition online oracle 12.2

In Oracle 12.2, We can split partitions or subpartitions online without impacting the DML statements. SQL> select partition_name,read_only,high_value from dba_tab_partitions where table_name='ORDER...

Read only Partition in Oracle 12.2

Till now we can make a table read only, But what about setting few partitions of a table to read-only. Thanks to Oracle 12.2 Release, We can do this. This is usually helpful, If requirement is to mak...

Move table online in Oracle 12.2

In previous Releases, To move a table to a different tablespace or segment, we need to take downtime for this activity And after moving the table, we have to rebuild/recreate the indexes. Now with Ora...

VARIABLE new feature in Oracle 12.2

You may use SQL*Plus to test queries with bind variables. Here is what you do before 12.2: SQL> variable text char SQL> exec :text:='X' PL/SQL procedure successfully completed. SQL> select * ...

spool CSV in Oracle 12.2

Now we can spool spool CSV or JSON from Oracle Database. Prior to 12.2 , we can spool as text or html, but from 12.2 onward, the SET MARKUP command now has a CSV option to output data in CSV format. S...

DBMS_TNS package for tnsping in database Oracle 12.2

DBMS_TNS package provides the RESOLVE_TNSNAME function to resolve a TNS name and return the corresponding Oracle Net8 connection string.When you connect locally to the server (no SQL*Net, no listener)...