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 : 29-04-2017

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

  • ora-16192 : Primary and standby network integrity mismatch
  • ora-13194 : failed to decode supercell
  • ora-09791 : slembdf: translation error, unable to translate error file name.
  • ora-13151 : failed to remove exception record
  • ora-28262 : global_context_pool_size has invalid value.
  • ora-23394 : duplicate propagator
  • ora-02213 : duplicate PCTUSED option specification
  • ora-36837 : (XSLMGEN07) Dimension string.string!string is missing a COLUMNNAME property value
  • ora-32155 : Anydata not specified
  • ora-28151 : more than one user name specified for command
  • ora-29975 : Cannot register a query in the middle of an active transaction
  • ora-06734 : TLI Driver: cannot connect
  • ora-14165 : MODIFY DEFAULT ATTRIBUTES FOR PARTITION may not be combined with other operations
  • ora-00105 : too many dispatcher configurations
  • ora-02833 : Server was unable to close file
  • ora-00153 : internal error in XA library
  • ora-01586 : database must be mounted EXCLUSIVE and not open for this operation
  • ora-22614 : error while construction the collection in the image
  • ora-02298 : cannot validate (string.string) - parent keys not found
  • ora-07303 : ksmcsg: illegal database buffer size.
  • ora-39167 : Tablespace string was not found.
  • ora-12168 : TNS:Unable to contact LDAP Directory Server
  • ora-30563 : outer join operator (+) not allowed in select-list
  • ora-10651 : incorrect file number block number specified
  • ora-24783 : Cannot switch non-migratable transactions
  • ora-02185 : a token other than WORK follows COMMIT
  • ora-16132 : An error occurred during activation of the standby.
  • ora-14066 : illegal option for a non-partitioned index-organized table
  • ora-24801 : illegal parameter value in OCI lob function
  • ora-19810 : Cannot create temporary control file string in DB_RECOVERY_FILE_DEST
  • 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.