ORACLE: TABLE PARTITIONING

Partitioning tables is simple and easy. Here is a demo to get started.
During range scans, with of course, proper indexes and stats, partitioned tables can provide
good response times.

SQL> CREATE TABLE NEW ( ID INT, NAME CHAR(5))
     PARTITION BY RANGE (ID)
     (PARTITION LESSTHAN1000 VALUES LESS THAN (1000),
     PARTITION LESSTHANMAXVALUE VALUES LESS THAN (MAXVALUE)
     );

SQL> DECLARE
     BEGIN
     FOR i in 1..2000
     loop
     THEN if mod(i,2)=0
     insert into new values (i,'RAMA')
     ELSE
     INSERT INTO NEW VALUES (i,'SITA')
     END IF; 
     END LOOP;
     END;

SQL> SELECT OWNER,TABLE_NAME,TABLESPACE_NAME,PARTITIONED FROM DBA_TABLES WHERE TABLE_NAME= 'NEW'