Home » SQL & PL/SQL » SQL & PL/SQL » How to create List by Range partition
How to create List by Range partition [message #211119] Tue, 26 December 2006 08:26 Go to next message
vipshiva
Messages: 1
Registered: December 2006
Junior Member
Hi,

If I execute the following query I am getting error stating that "Invalid Option"

CREATE TABLE tAT
(
dt date,
x int,
y int
)
PARTITION BY list (x)
subpartition by range(dt)
subpartition template
(
SUBPARTITION part1 VALUES LESS THAN (to_date('13-mar-2003','dd-mon-yyyy')),
SUBPARTITION part2 VALUES LESS THAN (to_date('14-mar-2003','dd-mon-yyyy')),
SUBPARTITION junk VALUES LESS THAN (MAXVALUE)
)
(

partition s1 values ( 1, 3, 5 ),
partition s2 values ( 2, 4, 6 )
)



Re: How to create List by Range partition [message #211122 is a reply to message #211119] Tue, 26 December 2006 08:52 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Do NOT report messages to get attention. Reporting messages is to alert moderators of abuse.
Re: How to create List by Range partition [message #211149 is a reply to message #211122] Tue, 26 December 2006 18:24 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
You can only Subpartition by LIST or HASH, and then only on a table that is RANGE partitioned.

RANGE is not valid for sub-partitioning.

Ross Leishman
Previous Topic: error using If statement in procedure
Next Topic: about commit Command
Goto Forum:
  


Current Time: Fri Dec 09 21:14:53 CST 2016

Total time taken to generate the page: 0.09211 seconds