How to Create Index Partitions to Ranged Partitioned Table
Starting with Oracle 8, Oracle allows for tables to be divided into different storage areas called partitions. Each …
Oracle
How to Move Partition Online in Oracle 12c
Starting 12c, Oracle has introduced a new feature for online movement of partitions. In this post we will discuss this …
What Is New in Oracle 11gR2 Relink
Methods to relink all binaries Oracle 11gR2 has two methods of relinking all product binaries in a home. 1. Traditional …
Unable to Create Shared Memory Segment ORA-27125 While Starting Database
The Problem The host ran out of disk space and ASM and the RDBMS were unable to create audit files. The environment was …
PL/SQL Script to Find VARCHAR2 Values That Cannot Be Converted to Number
This script contains a PL/SQL block to find VARCHAR2 values that cannot be converted to a number. It can be used to help …
The SQL Server Operating System (SQLOS)
The SQL Server Operating System (SQLOS) is a separate application layer at the lowest level of the SQL Server Database …
Compound Trigger Example in Oracle
The compound trigger is a new trigger that has been introduced in 11gR1. The compound trigger makes it easier to program …
Exadata Interview Questions - Smart Scan
What is Smart Scan? The data search and retrieval processing can be offloaded to the Exadata Storage Servers. This …
ORA-39142: Incompatible Version Number 5.1 in Dump File
The Problem Trying to export schema/tables from higher Database version 12.2.0.1.0 and import to version 12.1.0.1.0, …
Example of Specifying an INDEX Hint in Oracle
The format for an index hint is: select /*+ index(TABLE_NAME INDEX_NAME) */ col1... There are a number of rules that …
How Can We Have Different RMAN Retention Policies for Different Backups
We cannot have different retention policies for different backups. The retention policy is always the same for all …