2 Replies Latest reply: Dec 6, 2012 12:31 PM by rp0428 RSS

    ORA-00904: While adding partitions to a table

    IamHariKrishna
      10.2.0.5
      Rhel-5, 64 bit version


      SQL> ALTER TABLE AGENTSEO.BILLSTATUS SPLIT partition MAX_PART at (to_date('2013-02-01 00:00:00','YYYY-MM-DD HH24:MI:SS')) into
      (partition MAX_PART_JAN2013 tablespace DATA_JAN2013, partition MAX_PART) update indexes;

      ALTER TABLE AGENTSEO.BILLSTATUS SPLIT partition MAX_PART at (to_date('2013-02-01 00:00:00','YYYY-MM-DD HH24:MI:SS')) into
      *
      ERROR at line 1:
      ORA-00904: "SYS_C00012_12120510:50:38$": invalid identifier

      Anyone having any idea over this?

      Thanks