New Features for Oracle 11gR2 Relinking
This is a small note for the new features introduced in Oracle 11g related to Relinking. Methods of Relinking Oracle …
Oracle
What Is ODBC? How Does ODBC Work?
Open Database Connectivity (ODBC) provides a standard interface that allows application access to many different …
Understanding PL/SQL Blocks
Block Types A PL/SQL program comprises one or more blocks. These blocks can be entirely separate or nested within …
"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 …