-
create partition error
Hi gurus,
I have a table with more than 15 millions records. Its partitioned on range basis. The highiest value it had was 3500, and maxvalue based on the number of client facilities. Now i want to add some more partitions, and i'm getting following error. Please help me, this is on production. I've to do it before users come in. I've to add 6 more partitions to near about 11 tables like this.
I'm running oracle 9i on linux 7.1
Many thanks in advance
SQL> alter table d_XXX
add partition P_D_CLAIM_3600 VALUES LESS THAN (3700)
TABLESPACE XXXDATA01;
add partition P_D_CLAIM_3600 VALUES LESS THAN (3700)
*
ERROR at line 2:
ORA-14074: partition bound must collate higher than that of the last partition
SQL> select high_value from dba_tab_partitions where table_name='D_XXX' AND TABLE_OWNER='ABC';
HIGH_VALUE
--------------------------------------------------------------------------------
1100
1200
1300
1400
1500
1600
1700
1800
1900
2000
2100
HIGH_VALUE
--------------------------------------------------------------------------------
2200
2300
1000
2400
2500
2600
2700
2800
2900
3000
3100
HIGH_VALUE
--------------------------------------------------------------------------------
3200
3300
3400
3500
MAXVALUE
27 rows selected.
Thanks
PNRDBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|