3 Replies Latest reply: Dec 28, 2012 2:59 PM by 938302 RSS

    Partiotion table ORA-14074: partition bound must

    938302
      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