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 : 26-06-2017
ORA-14157

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

  • ora-29973 : Unsupported query or operation during change notification registration
  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-24090 : at least one protocol must be enabled
  • ora-01535 : rollback segment 'string' already exists
  • ora-30162 : The OCIFile context is not initialzed
  • ora-26083 : unsupported direct path stream version string
  • ora-16708 : the state supplied to resource guard is invalid
  • ora-12615 : TNS:preempt error
  • ora-27485 : argument string already exists at a different position
  • ora-29910 : invalid callback operation
  • ora-13788 : invalid recommendation type
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • ora-25107 : duplicate TABLESPACE option specification
  • ora-06033 : NETDNT: connect failed, partner rejected connection
  • ora-19242 : XQ0022 - namespace declaration attribute must be a literal
  • ora-09800 : Process sensitivity label retrieval failed.
  • ora-06922 : CMX: bad write length
  • ora-01716 : NOSORT may not be used with a cluster index
  • ora-00827 : could not shrink sga_target to specified value
  • ora-30052 : invalid lower limit snapshot expression
  • ora-13348 : polygon boundary is not closed
  • ora-16186 : Modifying LOG_ARCHIVE_CONFIG requires SID='*' qualifier
  • ora-16557 : the database is already in use
  • ora-18003 : an outline already exists with this signature
  • ora-01166 : file number string is larger than string (string)
  • ora-38758 : cannot flashback data file string; restored since last recovery
  • ora-22333 : cannot reset type "string"."string" due to invalid dependent types and tables
  • ora-29264 : unknown or unsupported URL scheme
  • ora-34726 : (NLSCHARSET06) CAUTION: String truncated during character set conversion from string to string
  • ora-14523 : Cannot co-locate [sub]partition of string string with table [sub]partition because string block size [string] does not match table block size [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.