ORA-14633: Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table

Cause : The caluse IVNALIDAET or UDPATE GOLBAL IDNEXES si alloewd onl yfor ADD hashs ubparittion ot a copmositep artitoined tbale.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Remov eclaus eand riessue poeratino

update : 24-09-2017

ORA-14633 - Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table
ORA-14633 - Index maintainence clause not allowed for ADD list subpartition to a Composite partitioned table

  • ora-24418 : Cannot open further sessions.
  • ora-26726 : logical standby and DOWNSTREAM_REAL_TIME_MINE are incompatible
  • ora-13774 : insufficient privileges to select data from the workload repository
  • ora-19113 : trace function called during evaluation: string
  • ora-31451 : invalid value string for capture_values, expecting: OLD, NEW, or BOTH
  • ora-00352 : all logs for thread string need to be archived - cannot enable
  • ora-28534 : Heterogeneous Services preprocessing error
  • ora-24305 : bad bind or define context
  • ora-38311 : cannot purge objects owned by other users
  • ora-33449 : (ESDREAD17) Discarding compiled code for workspace object because the partition method or partition dimension of number has changed since it was compiled.
  • ora-03250 : Cannot mark this segment corrupt
  • ora-06526 : Unable to load PL/SQL library
  • ora-07665 : ssrexhd: recursive exception encountered string string string string string string
  • ora-02007 : can't use ALLOCATE or DEALLOCATE options with REBUILD
  • ora-32627 : illegal pattern in MODEL FOR LIKE loop
  • ora-35180 : (SNSYN103) The format of the OUTFILE command is: OUTFILE [APPEND] {EOF | TRACEFILE | filename [NOCACHE] [NLS_CHARSET name]}
  • ora-01542 : tablespace 'string' is offline, cannot allocate space in it
  • ora-09830 : snyAddPort: failed to perform a remote procedure call.
  • ora-02882 : sou2o: Could not register SGA for protection
  • ora-06745 : TLI Driver: listener already running
  • ora-27459 : A program of type EXECUTABLE must have character-only arguments.
  • ora-30928 : Connect by filtering phase runs out of temp tablespace
  • ora-07680 : sou2os: another call to Oracle currently executing
  • ora-16767 : SQL Apply unexpectedly online
  • ora-02718 : osnprs: reset protocol error
  • ora-12018 : following error encountered during code generation for "string"."string"
  • ora-30183 : invalid field width specifier
  • ora-13123 : invalid name specified
  • ora-08462 : raw buffer contains invalid decimal data
  • ora-01196 : file string is inconsistent due to a failed media recovery session
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.