SQL & PL/SQL

Our database version 11.2.0.3

We have a parent table with 79 columns which is range - range composite partitioned as,

PARTITION BY RANGE ("SERIAL_NO")

  SUBPARTITION BY RANGE ("EX_DATE")

We have reference partitioned child table by referencing the primary key of parent table.  But the child tables have 1000 columns in them.  We are trying to split last partition, so to create quarterly partitions for Q4 2015 and so on.  But while splitting the partition on parent table we get below error,

    ALTER TABLE EXP_TABLE

SPLIT

  SUBPARTITION EXP_GRP1_T1_FUTURE     AT  ( TO_DATE(' 2016-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN') )

INTO (

    SUBPARTITION EXP_GRP1_T1_Q42015,

    SUBPARTITION EXP_GRP1_T1_FUTURE

);

Error report -

SQL Error: ORA-00604: error occurred at recursive SQL level 1

ORA-01792: maximum number of columns in a table or view is 1000

00604. 00000 -  "error occurred at recursive SQL level %s"

*Cause:    An error occurred while processing a recursive SQL statement

           (a statement applying to internal dictionary tables).

*Action:   If the situation described in the next error on the stack

           can be corrected, do so; otherwise contact Oracle Support.

Below is the full list of partition and subpartition with high value for parent table, basically its quarterly partition from Q1 2014.