Oracle Partitioning Quick Primer Partitioned Tables and Indexes
Archive for the ‘Tables’ Category
10 Mar
Managing Tables
Creating a Table The CREATE TABLE command is used to create relational tables or object tables. Relational table: This is the basic structure to hold user data. Object table: Is a table that uses an object type for a column definition. An object table is a table that is explicitly defined to hold the object [...]
10 Mar
Row Format
Oracle stores each row of a database table containing data for less than 256 columns as one or more row pieces. If an entire row can be inserted into a single data block, then Oracle stores the row as one row piece. However, if all of a row’s data cannot be inserted into a single [...]
10 Mar
ROWID Format
ROWID Format Extended ROWID An extended ROWID needs 10 bytes of storage on disk and is displayed by using 18 characters. It consists of the following components: •Data object number: Is assigned to each data object, such as table or index when it is created, and it is unique within the database •Relative file number: [...]
