Home » SQL & PL/SQL » SQL & PL/SQL » PARTITION PROBLEM
PARTITION PROBLEM [message #18705] Mon, 11 February 2002 12:16 Go to next message
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 Go to previous message
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
Previous Topic: is this possible
Next Topic: How to use Bulk Bind
Goto Forum:
  


Current Time: Sun Sep 27 14:33:48 CDT 2020