ORA-14173: illegal subpartition-extended table name syntax

Cause : Subpratitino to eb accsesed amy onyl be psecifeid usnig it sname .Usera ttemtped t ouse asubpratitino numebr ora bin dvaribale.

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

Modiyf staetmentt o reefr toa subaprtitoin usnig it sname

update : 24-06-2017

ORA-14173 - illegal subpartition-extended table name syntax
ORA-14173 - illegal subpartition-extended table name syntax

  • ora-27141 : invalid process ID
  • ora-16756 : resource guard could not open standby database read-only
  • ora-27454 : argument name and position cannot be NULL
  • ora-25954 : missing primary key or unique constraint on dimension
  • ora-10627 : Dump the content of the index leaf block
  • ora-07225 : sldext: translation error, unable to expand file name.
  • ora-14263 : new subpartition name must differ from that of any other subpartition of the object
  • ora-30766 : cannot modify scope for a REF column with a REFERENCES constraint
  • ora-33445 : (ESDREAD15) Discarding compiled code for workspace object because workspace object and workspace object, which were not partition-dependent when the code was compiled, are now partition-dependent.
  • ora-13369 : invalid value for etype in the 4-digit format
  • ora-25468 : column name not specified for alias: string
  • ora-26692 : invalid value string, string should be in string format
  • ora-24307 : invalid length for piece
  • ora-16088 : archive log has not been completely archived
  • ora-27008 : function called with invalid file structure
  • ora-32608 : missing INCREMENT or DECREMENT keyword in FOR loop
  • ora-24385 : Application context size or index is not valid
  • ora-12018 : following error encountered during code generation for "string"."string"
  • ora-28008 : invalid old password
  • ora-23400 : invalid materialized view name "string"
  • ora-14281 : CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-02756 : osnfsmnam: name translation failure
  • ora-01345 : must be a LogMiner coordinator process
  • ora-16209 : Logical standby dictionary build failed to complete.
  • ora-40213 : contradictory values for settings: string, string
  • ora-38491 : could not evaluate subexpression for rowid "string"
  • ora-06003 : NETASY: port write failure
  • ora-08401 : invalid compiler name: string
  • ora-23365 : site string does not exist
  • ora-32006 : %s initialization parameter has been deprecated
  • 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.