Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Partitioning Table
news <danmary_at_home.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
news:TM4W3.43543$it.940045_at_news2.rdc1.on.home.com¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> How do I enable table partitioning in Oracle 8.0.4?
>
>
>
CREATE TABLE table_name
(Column1 type,
Column2 type,
...
Column9 type)
PARTITION BY RANGE(column1)
(PARTITION P1 VALUES LESS THAN (VALUE1) TABLESPACE TS1,
PARTITION P2 VALUES LESS THAN (VALUE2) TABLESPACE TS2,
...
PARTITION PX VALUES LESS THAN (MAXVALUE) TABLESPACE TSX);
Received on Thu Nov 11 1999 - 00:00:00 CST