list - list partiton in 10g is it allowed?

[goodmans]

Is list-list partitioning is alowed in 10g?

I am trying to create the below table its giving an error like missing or invalid option. Am I missing anything?

create table test_part (
bk_col varchar2(8),
sid varchar2(4),
current_record_flag varchar2(1)
)
partition by range (SID)
subpartition by list (current_record_flag)
subpartition template (
subpartition cr_part_y values ('Y'),
subpartition cr_part_n values ('N')
)

(
partition a_PART values ('ABC')
partition B_PART values ('BCA')
)

Regards
G

 

[Dagon]

Allowed partitioning methods are:

Range partitioning

Hash partitioning

List partitioning

Composite range-hash partitioning

Composite range-list partitioning

Since composite list-list is not mentioned, I suspect it's not supported.

 

[goodmans]

Is there any way to do this in 10g?
create range partitiion but condition is
value betwee 1 and 1

Regards
G

 

[Dagon]

Depending on the length of your key values, you may be able to append something to the end of each one so that they go into the correct partitions e.g.

create table test_part (
bk_col varchar2(8),
sid varchar2(4),
current_record_flag varchar2(1)
)
partition by range (SID) 
          subpartition by list (current_record_flag)
              subpartition template (
                    subpartition cr_part_y values ('Y'),
                    subpartition cr_part_n values ('N')
                    ) 
(
  partition a_PART values less than ('ABCZ'),
  partition B_PART values less than ('BCAZ'),
  partition c_part values less than (maxvalue)
)

 

[goodmans]

Thanks mate it works.

Regards
G