Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: Shaw John-P55297 [SMTP:[EMAIL PROTECTED]]
> Sent: Mon, March 18, 2002 5:41 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Another partitioning question part 2
>
> I tried
I tried the partition by range feature and didn't get the results I
expected. It seemed to ignore the second key when inserting data.
create table test_part(
id number(11) ,
owner_id number(11) not null,
owner varchar2(30) not null,
street varchar2(40))
partition by range(owner,owner_id )
(
partit