Perform Flashback in pluggable database(PDB) in oracle 12.2
In oracle 12.2 version, we can perform flas...
oracle 12.2.
TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump
TRUST_EXISTING_TABLE_P...
OUTBOUND_DBLINK_PROTOCOLS in oracle 12.2
OUTBOUND_DBLINK_PROTOCOLS specifies the network protocols a...
Local/Shared Undo mode in oracle 12.2 multitenant database
There are two undo modes in oracle 12.2 M...
Split partition online oracle 12.2
In Oracle 12.2, We can split partitions or subpartitions online ...
Read only Partition in Oracle 12.2
Till now we can make a table read only, But what about setting f...
Move table online in Oracle 12.2
In previous Releases, To move a table to a different tablespace or...
VARIABLE new feature in Oracle 12.2
You may use SQL*Plus to test queries with bind variables. Here ...
spool CSV in Oracle 12.2
Now we can spool spool CSV or JSON from Oracle Database. Prior to 12.2 , w...
DBMS_TNS package for tnsping in database Oracle 12.2
DBMS_TNS package provides the RESOLVE_TNSNAME ...