From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Schema objects: All about tables - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Schema objects: All about tables

“

- [Instructor] Let's now look at Oracle schema objects. In this video, we will understand what Oracle objects are specifically tables and delve into details of heap organized tables and the less common data bearing table structures in the Oracle database. Tables are essential structures where data is stored and the basic means of retrieval in Oracle 23 C. Let's cover how they interact and the role they play in database management. The most common table format is heap organized. Oracle with its definitive unique identifier, the ROWID allows impressive performance even when data stored without indexing, sorting and reorganizing using that ROWID for quick identification when performing table scans. Oracle is the only enterprise database solution with the ROWID feature default to any table creation. External tables are objects that reside outside of database data file structures, but have features similar to traditional tables. This provides access to documents such as data in traditional formats like column separated format, CSV, and other files changes can be performed via Oracle data pump or with an insert into statement. Clustered tables are a group of tables that share the same data blocks because they are often used together. The cluster is defined based on one or more columns known as the cluster key that the tables have in common. Upon the Create Cluster command, Oracle stores all rows for each cluster key value in the same blocks. This means that if you often need to join several tables on the same columns, a cluster can provide the performance of these joins by reducing the IO required to access the rows. This means that if you often need to join several tables on the same columns, a cluster can improve the performance of these joins by reducing the IO required to access the rows. Alternative table formats provide different performance benefits and are suitable for specific types of data access patterns. The decision to use one over the other typically depends on the specific requirements of the application and the access patterns of the data. Understanding how best to design table structures is essential as a database administrator in Oracle. Although heap tables are the majority of what you'll work with, it's worth your time to understand what options are available to meet the needs of the organization.

Contents