ORACLE 12C

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.

Now connect to the PDB for which you are setting up listener.

Set listener_networks: use the listener port and the hosname

Check the status of the listener:

[…]

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 DB user, which work perform an activity in all the containers including root container of the CDB. 2.A common user can only be created in […]

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 undo tablespace. Share Undo mode: In this mode, There will be only one undo tablespace for the instance. […]

Split partition online oracle 12.2

In Oracle 12.2, We can split partitions or subpartitions online without impacting the DML statements.

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 make the historical data not editable.

SYNTAX – ALTER TABLE MODIFY PARTITION READ ONLY;

If you tried […]

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 Oracle 12.2, We can move the table online to a different segment or tablespace, without impacting the DML activities and without […]

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:

Now in 12.2 is so simple

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. Syntax CSV {ON|OFF} [DELIMI[TER] character] [QUOTE {ON|OFF}] Traditionally you wiill get formatted output (without […]

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), the Oracle session inherits the client environment.   It is available on oracle 12.2 Release . The DBMS_TNS package contains one function, RESOLVE_TNSNAME, which returns the […]

Long Identifiers In Oracle 12.2

SQL*Plus now supports object lengths of 128 bytes. In previous releases, the object length limit was 30 bytes and if you try to create object with length more than 30, it will throw error as ORA-00972: identifier is too long. Oracle 12.2 increases the maximum size of most identifiers from 30 to 128 bytes, which […]

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