Segment

Segments vs Schema Objects

Posted on
Segments vs Schema Objects No only showing all tables in Oracle, for better understanding the nature of table, you also need to know the definitions of segment and schema object in Oracle world. Segments A segment in an Oracle database is a set of extents that contains all the data for a specific logical storage […]
Index

How to Resolve ORA-08102: index key not found

Posted on
ORA-08102 Found some ORA-08102 errors during executions of SQL statements like this: ERROR at line 1: ORA-08102: index key not found, obj# 98830, file 69, block 120164 (2) ERROR at line 1: ORA-08102: index key not found, obj# 98832, file 69, block 120172 (2) ERROR at line 1: ORA-08102: index key not found, obj# 98831, […]
SQL

How to Resolve ORA-00903: invalid table name

Posted on
In this post, I will introduce 3 main error patterns about ORA-00903, they are: Violating Naming Rules Missing Quotes Incorrect Syntax ORA-00903 due to Violating Naming Rules Without complying with database object naming rules, we can’t create a table with unusual strings in normal way. Let’s see some cases that throw ORA-00903. First of all, […]
Data Dictionary View

How to Find Biggest Segments in Oracle

Posted on
Find Biggest Segments A segment in Oracle database is a set of extents that contains all the data for a specific logical storage structure within a tablespace. Which means segments contain not only metadata but real data. Normally, segments include tables, indexes and large objects, etc. Let’s see what biggest segments are in our database. […]