Solved

ORA-14080: partition cannot be split along the specified high bound

Posted on 2008-09-29
6
2,994 Views
Last Modified: 2013-12-21
Experts,

i had accidentally dropped one partition. now i am trying to create partition. i am getting following error.
ERROR at line 1:
ORA-14080: partition cannot be split along the specified high bound

can any one help me to fix this problem.

please find the table script

rawtxn-table-script.txt
0
Comment
Question by:pavan27
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
6 Comments
 
LVL 28

Expert Comment

by:Naveen Kumar
ID: 22602867
what is the partition name which you dropped ?

what is the current sql which you are running now in order to recreate the partition ? I mean which sql command is giving the error you posted already.
0
 
LVL 7

Expert Comment

by:grzessio
ID: 22603442
you are trying to split wrong partition (probably RAWTXN_MAX)

you have to split "next" partition to the one that you dropped.
eg. if you dropped partition RAWTXN_200802 you have to split partition RAWTXN_200803
if you dropped partiiton RAWTXN_200805 you have to split partition RAWTXN_200806
ALTER TABLE RAWTXN
SPLIT PARTITION RAWTXN_200803
AT (TIMESTAMP'2008-03-01 00:00:00')
INTO (PARTITION RAWTXN_200802, PARTITION RAWTXN_200803)
UPDATE GLOBAL INDEXES;
 
you will probably have to rebuild local indexes on splitted partition.

Open in new window

0
 
LVL 1

Author Comment

by:pavan27
ID: 22606753
i was dropped rawtxn_200710, rawtxn_200711, rawtxn_200712
0
 
LVL 7

Expert Comment

by:grzessio
ID: 22606831
then try:
ALTER TABLE RAWTXN
SPLIT PARTITION RAWTXN_200801 
AT (TIMESTAMP'2007-11-01 00:00:00')
INTO (PARTITION RAWTXN_200710, PARTITION RAWTXN_200801)
UPDATE GLOBAL INDEXES;
 
ALTER TABLE RAWTXN
SPLIT PARTITION RAWTXN_200801 
AT (TIMESTAMP'2007-12-01 00:00:00')
INTO (PARTITION RAWTXN_200711, PARTITION RAWTXN_200801)
UPDATE GLOBAL INDEXES;
 
ALTER TABLE RAWTXN
SPLIT PARTITION RAWTXN_200801 
AT (TIMESTAMP'2008-01-01 00:00:00')
INTO (PARTITION RAWTXN_200712, PARTITION RAWTXN_200801)
UPDATE GLOBAL INDEXES;

Open in new window

0
 
LVL 7

Accepted Solution

by:
grzessio earned 500 total points
ID: 22606837
try it in order that I gave you.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
pl/sql - query very slow 26 89
ORA-02288: invalid OPEN mode 2 87
Email query results in HTML 6 38
Cannot connect to Oracle database, python not recognizing cx_Oracle 2 31
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question