Home » RDBMS Server » Server Administration » Re: PARTITION
Re: PARTITION [message #52206] Tue, 09 July 2002 04:33
Depa
Messages: 30
Registered: June 2002
Member
create table ai90
(eno number,
cdate date)
PARTITION BY RANGE (cdate)
( PARTITION p_date1 VALUES LESS THAN '01-FEB-2001'
TABLESPACE yours
STORAGE (INITIAL 500M, NEXT 5M, PCTUSED 99, PCTFREE 1),
PARTITION p_date2 VALUES LESS THAN '01-MAR -2001'
TABLESPACE yours
STORAGE (INITIAL 500M, NEXT 5M, PCTUSED 99, PCTFREE 1),
.
.
.

)

Report message to a moderator

Previous Topic: Oracle 9i Installation on HP-9000 N Class HP-UX 11
Next Topic: Re: OEM - OMS Service won't start
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 25 22:01:50 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.