This discussion is archived
3 Replies Latest reply: Dec 28, 2012 12:59 PM by 938302 RSS

Partiotion table ORA-14074: partition bound must

938302 Newbie
Currently Being Moderated
Hi Team,

I have a DB 9.2.0 On unix server


     
     

RENZO.MENDEZ@PEPSICO.COM     - 3 mins ago          [Customer Problem Description]
Customer Image          
     
Customer Problem Description
---------------------------------------------------

Problem Summary
---------------------------------------------------
ORA-14074: partition bound must collate higher than that of the last partition

Problem Description
---------------------------------------------------
ORA-14074: partition bound must collate higher than that of the last partition


Error Codes
---------------------------------------------------


Problem Category/Subcategory
---------------------------------------------------
Segment and Tablespace Space Management

Uploaded Files
---------------------------------------------------


Template Question Responses
---------------------------------------------------
1) On what tablespace do you encounter the issue? (SYSTEM, SYSAUX, Temporary, UNDO or User created)
USERS

2) ### If you are receiving errors, please list the exact error messages and message text.###
I have a partion table FACT_VENTAS

I created the partion:

P145_FACT_VENTAS
P147_FACT_VENTAS


PARTITION P145_FACT_VENTAS VALUES LESS THAN (TO_DATE(' 2013-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
LOGGING
NOCOMPRESS
TABLESPACE PARTITION_DATAW1
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 128K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
),

PARTITION P147_FACT_VENTAS VALUES LESS THAN (TO_DATE(' 2013-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
LOGGING
NOCOMPRESS
TABLESPACE PARTITION_DATAW1
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 128K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT

After When I try Created a new partition P146_FACT_VENTAS. I have problems.

alter TABLE dataw1.FACT_VENTAS ADD PARTITION P146_FACT_VENTAS VALUES LESS THAN (TO_DATE(' 2013-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
LOGGING
NOCOMPRESS
TABLESPACE PARTITION_DATAW1
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 128K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
BUFFER_POOL DEFAULT
);

ERROR at line 1:
ORA-14074: partition bound must collate higher than that of the last partition

Regards,

Guido

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points