Oracle and DB2, Comparison and Compatibility/Storage Model/Tables/Oracle


Tables are logical structures that the end user works with, they contain columns and rows. Columns describe attributes of rows in the table, and each column has a name (i.e. Social_Security_Number), a data type and width, precision or scale. When tables are created, Oracle allocates a segment in the table space for the table. Data is added, removed, selected and changed by database row, and this is usually done through SQL

Oracle Tables in a Tablespace