Database DataWarehousing (MOSC)

MOSC Banner

partition range (empty) partition:invalid

edited Jan 15, 2013 3:57PM in Database DataWarehousing (MOSC) 3 commentsAnswered

SQL> Select count(*) from cy_work where work_id = '10316'; --### why no records returned?
 
  COUNT(*)
----------
         0

SQL> Select count(*) from cy_work where work_id = 10316; --### records returned number value
 
  COUNT(*)
----------
     78121


Table partitioned by range on WORK_ID, data type varchar2(5)

Some of partition definitions:
PARTITION PM005_WORK VALUES LESS THAN ('08947')
PARTITION PM006_WORK VALUES LESS THAN ('10484')
PARTITION PM007_WORK VALUES LESS THAN ('13674')

Data was meant to be in partition PM006_WORK which has a top value of 10483 higher that 10316
But data is located in partition PM007_WORK....Why is this so?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center