How to Resolve ORA-02180: invalid option for CREATE TABLESPACE
While creating tablespace if you're getting the error ORA-02180, then this article is for you which will help you to resolve this. Mainly this is a syntax error. So this…
How to add tempfile to temp tablespace in Oracle: Easy Guide
In Oracle databases, temp tablespaces are crucial for managing temporary data generated during operations like sorting, joining tables, and running complex queries. This blog post will guide you on how…
How to add datafile in tablespace in Oracle: Easy Guide
In Oracle Database, managing tablespace is crucial to maintain optimal performance and avoid downtime. When a tablespace is running low on space, you have two options: resizing the existing datafile…
How to Determine Oracle Database Schema Size: A Comprehensive Guide
Understanding Oracle database schema size is crucial for performance tuning, capacity planning, and effective resource management when managing Oracle databases. As an experienced Oracle DBA, I’ll guide you through various…
How to find Scheduler Jobs in Oracle: Easy Guide
Query 1: Find Scheduler Job Details :Query 2: Find the scheduler job run Details:Query 3: Find the scheduler job log Details:Query 4: Find the currently running job details : Query…
How to find all the DB_Link Details in Oracle database: Easy Guide
Today in this article we will see how to find all the db_link details in Oracle Database. Let's go through this : Find all the DB_Link Details in Oracle :…
How to check index size in Oracle: Easy Guide
In this article, I will provide a detailed guide on how to check index size in Oracle. We'll walk you through each step of the process with proper screenshots. Let's…
How to check table size in Oracle: Easy Guide
In this article, I will provide a detailed guide on how to check table size in Oracle. We'll walk you through each step of the process with proper screenshots. Let's…
How to check CDB size & PDB size in Oracle database: Easy Guide
Welcome to our guide on how to check CDB size & PDB size in the Oracle database. Let's open VirtualBox and get started! 1. Find only CDB size2. Find CDB…
How to find Oracle database size: Easy Guide
Welcome to our guide on how to find Oracle database size. Whether you're a beginner or an expert, you'll find valuable insights here. 1. Check allocated space2. Check the occupied…