PARTITION PROBLEM [message #18705] |
Mon, 11 February 2002 12:16 |
lily
Messages: 44 Registered: September 2000
|
Member |
|
|
Hi.
db: oracle 8.1.7
table: 'xxx'
columns (in 'xxx'table ) : 'a1', 'a2','a3','a4'.
data in column 'a1': 'NJ', 'CA', 'NY'
NB: column 'a1' contains 6000 rows for 'NJ'.
Now, I want to create a partition for column 'a1' which should only hold 'NJ'. How do I define this?
I am confused to use 'By Range'.
Please help.
lily.
|
|
|
Re: PARTITION PROBLEM [message #18706 is a reply to message #18705] |
Mon, 11 February 2002 12:26 |
Mike
Messages: 417 Registered: September 1998
|
Senior Member |
|
|
If you are using oracle8i use range partitionning like:
PARTITION BY RANGE (a1)(
PARTITION part_ca VALUES LESS THAN ('NJ'),
PARTITION part_nj VALUES LESS THAN ('NY'),
PARTITION part_ny VALUES LESS THAN (MAXVALUE)
)
If you are using oracle9i use liste partitionning like:
PARTITION BY LIST (a1) (
PARTITION part_ca VALUES ('CA'),
PARTITION part_nj VALUES ('NJ'),
PARTITION part_ny VALUES ('NY'))
HTH
Mike
|
|
|