|
|
| Re: PARTITION CAN NOT BE SPLIT ALONG THE SPECIFIED HIGH BOUND... [message #154806 is a reply to message #154586] |
Tue, 10 January 2006 13:30   |
dbaxchangedba
Messages: 26
Registered: November 2005
|
Junior Member |
|
|
ALTER TABLE P_SERVICE
SPLIT PARTITION FB_100000000 AT (100000000) INTO
(PARTITION FB_1204915 tablespace USERS,
PARTITION FB_100000000 tablespace USERS)
UPDATE GLOBAL INDEXES;
The split partition usually works this way (taking your case above):
The split partition will try to assign the value supplied with "AT" to be FB_1204915's high value. If 100000000 is the high value for partition FB_100000000 then it cannot assign the same high value to 2 partitions. Split partition works by splitting / dividing an existing partition in to 2 at the value specified through "AT" clause. The new partition gets its high value from the value specified at "AT" while the partition that's being split will continue to have its current high value.
You can try a couple of things for this to work:
(Case 1)
If there are other partitions after FB_100000000, then merge the next partition immediately after FB_100000000 with FB_100000000 and then try the above split at 100000000.
(Case 2)
If FB_100000000 is the last partition within the P_SERVICE table then you can do this:
(a) Add a partition to the table whose high value is maxvalue
SQL> alter table P_SERVICE add partition FB_maxvalue values less than (maxvalue);
(b) Merge FB_100000000 with FB_maxvalue
SQL> alter table P_SERVICE merge partitions FB_100000000 , FB_maxvalue into partition FB_MAXVAL nologging;
(c) You can now perform the split:
alter table P_SERVICE split partition FB_MAXVAL at (100000000) into
(PARTITION FB_1204915 tablespace USERS,
PARTITION FB_100000000 tablespace USERS)
UPDATE GLOBAL INDEXES;
Partition FB_100000000 will now have a high value of maxvalue while partition FB_1204915 will have a high value of 100000000.
If you do not want a partition with a high value of maxvalue then you can split FB_100000000 further by supplying a new high value for it and drop the last partition.
Good Luck!
http://www.dbaxchange.com
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
