Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Mis behaving partition on Oracle8 ?
Hi
I have created table on Oracle8 with 4 partitions. The 2nd partition has
zero number of rows. I have built local indexes on each of the partition
with single name. When I nalyze the partitions and indexes I see the
difference in number of rows.
i,e
partiton 1 has 600000 number of rows where as index on this partition
has 0 rows.
Where as 2 parttion has 0 rows but the index on it has 220,000 rows.
How can it be possible. I have also attached the script I used to create
the index.
Can some one help me ?
Thanks
Drona
create index CDR_R_1 on CDR ( receive_time desc )
tablespace CDR_INDEX_01
local (
partition CDR_01
tablespace CDR_INDEX_01
nologging
storage (
initial 13787136
next 13787136
maxextents 2)
,
partition CDR_02
tablespace CDR_INDEX_02
nologging
storage (
initial 13787136
next 13787136
maxextents 2)
,
partition CDR_03
tablespace CDR_INDEX_03
nologging
storage (
initial 13787136
next 13787136
maxextents 2)
,
partition CDR_04
tablespace CDR_INDEX_04
nologging
storage (
initial 13787136
next 13787136
maxextents 2)
)
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Oct 29 1999 - 09:47:37 CDT