That's it!
Thanks for the help
I with I could go 9i.

Mike
[Email Address Removed] Original Message -----
From: "Mary Bahrami" <[Email Address Removed] "Michael McMullen" <[Email Address Removed] Monday, June 30, 2003 2:35 PM
Subject: RE: range partition question


The second column is evaluated only if the first column <equals> the
range_value. If you change the create table to:
create table test_part
(accesstype varchar2 (20),
language varchar2 (20)
)
PCTFREE 10
PCTUSED 60
STORAGE (INITIAL 8k next 8k)
partition by range (accesstype,language)
(partition p1 values less than ('EXTERNAL','EZ'),
partition p2 values less than ('EXTERNAL','FZ'),
partition p3 values less than ('INTERNAL','EZ'),
partition p4 values less than ('INTERNAL','FZ'))
;

you get distribution into all 4 partitions. Maybe use list partitioning?

-----Original Message-----
From: Michael McMullen [mailto:[Email Address Removed] Monday, June 30, 2003 9:30 AM
To: LazyDBA.com Discussion
Subject: range partition question


Oracle 8.1.7.4
I know I'm using characters for my range.

partition by range(accesstype,language)
(partition p1 values less than ('EZ','EZ') tablespace typemenu_part1,
partition p3 values less than ('EZ','FZ') tablespace typemenu_part3,
partition p2 values less than ('IZ','EZ') tablespace typemenu_part2,
partition p4 values less than ('IZ','FZ') tablespace typemenu_part4,
partition bad_part values less than (MAXVALUE,MAXVALUE) tablespace
typemenu_part3
)

I'm getting
select distinct accesstype,languagefrom asset.admin_typemenu_temp partition
(p1)
returns
EXTERNAL ENGLISH
EXTERNAL FRENCH

select distinct language,accesstype from asset.admin_typemenu_temp partition
(p2)
returns
INTERNAL ENGLISH
INTERNAL FRENCH

How come nothing in partitions p3 & p4?

Mike
[Email Address Removed] documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page