ORA-14157: invalid subpartition name

Cause : a usbpratiitonn am eoft hef or mr i sexepctde btu nto persetn.

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

enetr na approrpiaet sbupatritoin anme.

update : 24-04-2017
ORA-14157

ORA-14157 - invalid subpartition name
ORA-14157 - invalid subpartition name

  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-29330 : Source script length too big
  • ora-10657 : Lob column to be shrunk does not exist
  • ora-26509 : null materialized view control structure
  • ora-32300 : cannot drop a secondary materialized view "string"."string"
  • ora-16062 : DGID from standby not in Data Guard configuration
  • ora-23497 : repgroup name cannot be null
  • ora-14620 : DEFAULT subpartition already exists
  • ora-24083 : cannot specify remote subscribers for string QUEUE string
  • ora-16009 : remote archive log destination must be a STANDBY database
  • ora-31689 : illegal value for base worker id, string
  • ora-06960 : Failed to access log file
  • ora-16031 : parameter string destination string exceeds string character limit
  • ora-12608 : TNS: Send timeout occurred
  • ora-00394 : online log reused while attempting to archive it
  • ora-00220 : control file not mounted by first instance, check alert log for more info
  • ora-17502 : ksfdcre:string Failed to create file string
  • ora-35076 : (QFHEAD04) CAUTION: The textual data in EIF file string is encoded in a character set that is not recognized by this version of string.
  • ora-02228 : duplicate SIZE specification
  • ora-23337 : priority or value not in priority group string
  • ora-12471 : Specified compartment or group is not authorized for user
  • ora-26748 : The one-to-one transformation function string encountered the following error: string
  • ora-28340 : a different encryption algorithm has been chosen for the table
  • ora-12599 : TNS:cryptographic checksum mismatch
  • ora-25200 : invalid value string, QUEUE_NAME should be [SCHEMA.]NAME
  • ora-27191 : sbtinfo2 returned error
  • ora-38436 : attribute set used for an Expression set may not be modified.
  • ora-12163 : TNS:connect descriptor is too long
  • ora-00991 : only MAC privileges may be granted to procedures
  • ora-19015 : Invalid XML tag identifier (string)
  • 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.