Create table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Create table

  1. #1
    Join Date
    Mar 2001
    Posts
    188
    I have suddenly a simple question.
    i will create a table with the following code:

    CREATE TABLE TEST
    (
    column1 VARCHAR2
    )
    ORGANIZATION HEAP
    MONITORING
    /

    What means the parameter:

    1) organization heap
    2) monitoring.

    Means monitoring the tables will be analyzed by oracle-db himself.
    Best Regards
    Thomas Schmidt

    Thomas_Schmidt@eplus-online.de
    If you have no aims, you will never reach a goal !!!

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    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 )
    ORGANIZATION HEAP
    MONITORING ;
    What means the parameter:
    1) organization heap
    2) monitoring.
    Means monitoring the tables will be analyzed by oracle-db himself.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width