* Long datatypes are discouraged in Oracle 8.Note that are long and blob datatypes are incompatible.

2. Creating a Table.

PCTFREE = Amount of space to leave in block during insert operations. Allows room for records to grow within the same area.PCUSED = The threshold at which the block is placed back on the free block list.INITIAL/NEXT = The initial disk allocated, and the next extent size.LOGGING = Indicates whether operations are written to the redo logs.

Table partitioning is the best feature ever added to the Oracle RDBMS.Chunks of data can be appended, replaced, or purged very easily whenusing table partitioning. When you have more than 20 million rows in anon-static table, partitioning is recommended. We found that bitmapindexes work better than standard indexes on partitioned tables.