Home 2023 February

Monthly Archives: February 2023

Five planes from five different

How to rename Duplicate datafile names in Oracle??

11g database - Datafile created with extra blank space similar to existing datafile. Please note that oracle database will not allow exact datafile name,...

How To Modify AWR Snapshot Setting ??

We can change the snap_interval and retention period for the automatic awr snapshot collection, using modify_snapshot_settings function. The default settings for ‘interval’ and ‘retention’ are...
yellow scrabble tiles

ORA-12101: Materialized View Issue

During 19c Upgrade, Materialized view creation which is from a pre-built base table is showing COMPILATION ERROR without any specific error messages. Base table column...

ORA-39358: Export Dump File Version Not Compatible With Target Version 

After upgrading a database from to, the following errors are reported executing a datapump import process: Import: Release - Production Copyright...

RAID (Redundant Array of Inexpensive disks)

RAID stands for Redundant Array of Inexpensive Disks which was later interpreted to Redundant Array of Independent Disks. This technology is now used in...
red check mark on box in close up view

What is Checkpoint ?

A checkpoint is an operation that Oracle performs to ensure data file consistency. When a checkpoint occurs, Oracle ensures all modified buffers are written...
PDF file png sticker, digital

Grid Infrastructure Files and Management Database in RAC

Oracle 19c Grid Infrastructure requires certain files and provides tools to access each Standalone Cluster . It should have a Grid Infrastructure Management Repository...