From Oracle Documentation:
1) ORGANIZATION HEAP specifies that the data rows of table are stored in no particular order. This is the default.
ORGANIZATION INDEX specifies that table is created as an index-organized table. In an index-organized table, the data rows are held in an index defined on the primary key for the table.
2) MONITORING specifies that modification statistics can be collected on this table. These statistics are
estimates of the number of rows affected by DML statements over a particular period of time. They are available for use by the optimizer or for analysis by the user.
Originally posted by tomate I have suddenly a simple question.
i will create a table with the following code:
CREATE TABLE TEST
( column1 VARCHAR2 )
What means the parameter:
1) organization heap
Means monitoring the tables will be analyzed by oracle-db himself.