Understanding PL/SQL Blocks
Block Types A PL/SQL program comprises one or more blocks. These blocks can be entirely separate or nested within …
Oracle
"Communication Error With the OPMN Server Local Port" When Starting OPMN
The Problem When attempting to start the OPMN services the following error occurs: opmnctl: starting opmn and all …
How to Check and Set Max Size of PDB Storage
You can specify the maximum size for any PDB database using STORAGE clause in CREATE PLUGGABLE DATABASE command. If we …
How to Shrink the Datafile of Temporary Tablespace in Oracle
The database has a program that performs a huge sort operation (e.g. end of the year reporting process). This may cause …
Queries to Find Information and Work With Oracle Container Database (CDB) and Pluggable Database (PDB)
This post lists out different administrative tasks you can perform in a container database (CDB) and pluggable database …
How to Shrink a Temporary Tablespace in Oracle
Question: How to resize the TEMPFILE(s) for a temporary tablespace after they have grown larger than needed? Large sort …
Temporary Tablespaces Group in Oracle
This post explains why and how to create groups of temporary tablespaces. Grouping temporary tablespaces within a single …
How to Move a Datafile to a Different Location on Physical Standby Database
Sometimes it is necessary to move a Datafile to another Location (eg. Mountpoint, ASM Diskgroup, etc.) due to Space …
How to Restore and Recover Single or Multiple Datafiles From a PDB Database
The Setup We will be using below setup for the purpose of this post: CDB name:CDB1 PDB name: pdbtest CDB1 …
How to Setup Transparent Data Encryption (TDE) in Oracle 12c for Non-Pluggable Database
TDE was introduced as of 10gR2 ( 10.2.0.1 ). In 12c TDE provides a completely different interface to manage the wallet …
How to Roll Forward a Physical Standby Using Recover From Service Command in Data Guard 12c
Rolling Forward a Physical Standby Database Using the RECOVER FROM SERVICE Command A standby database is a …