OraFAQ Forum: Server Administration » Oracle range partitioning

Home » RDBMS Server » Server Administration » Oracle range partitioning (10GR2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle range partitioning [message #475217]

Mon, 13 September 2010 14:23

Sunny_0009
Messages: 1
Registered: September 2010

Junior Member

Hi Guys,

Environment
I have a database 10.2.0.4 running on 64bit Solaris 5.10 SPARC.

Question:

CREATE TABLE SYSTEM.BIG_TABLE1
(
ID NUMBER(10),
LOOKUP_ID NUMBER(10),
DATA VARCHAR2(50 BYTE)
)
PARTITION BY RANGE (ID)
(
PARTITION BIG_TABLE_2003 VALUES LESS THAN (1000000000)
LOGGING
NOCOMPRESS,
PARTITION BIG_TABLE_2004 VALUES LESS THAN (5000000000)
LOGGING
NOCOMPRESS,
PARTITION BIG_TABLE_2005 VALUES LESS THAN (MAXVALUE)
LOGGING
NOCOMPRESS
)

When I query dba_tab_partitions. I get this result

select table_name, partition_name, high_value, high_value_length from dba_tab_partitions where table_name = 'BIG_TABLE1' ;

table_name partition_name high_value HIGH_VALUE_LENGTH
------------- -------------- ---------- -----------------
BIG_TABLE1 BIG_TABLE_2003 1000000000 10
BIG_TABLE1 BIG_TABLE_2004 5000000000 10
BIG_TABLE1 BIG_TABLE_2005 MAXVALUE 8

3 rows selected.

Now my question is why do I see max_value_lengh=8 when my column value is 10.

I don't get any error. But I do like to understand it. Razz