RE: Another partitioning question part 2

2002-03-19 Thread אדר יחיאל
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

Another partitioning question part 2

2002-03-18 Thread Shaw John-P55297
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