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 : 22-08-2017

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

  • ora-14317 : cannot drop the last value of partition
  • ora-10930 : trace name context forever
  • ora-16400 : quota attributes are not allowed with DB_RECOVERY_FILE_DEST
  • ora-02706 : osnshs: host name too long
  • ora-00040 : active time limit exceeded - call aborted
  • ora-02074 : cannot string in a distributed transaction
  • ora-39024 : wrong schema specified for job
  • ora-36861 : (XSTFRC01) SQL Cache ID parameter is invalid or missing.
  • ora-00290 : operating system archival error occurred. See error below
  • ora-37076 : (XSMCSESS04) workspace object is not the type of dimension that can have session-only values. Valid types are TEXT, NTEXT, ID, NUMBER, and CONCAT with the UNIQUE attribute.
  • ora-00382 : %s not a valid block size, valid range [string..string]
  • ora-07249 : slsget: open error, unable to open /proc/pid.
  • ora-02338 : missing or invalid column constraint specification
  • ora-01466 : unable to read data - table definition has changed
  • ora-16637 : an instance failed to access the Data Guard broker configuration
  • ora-01751 : Invalid dump undo option
  • ora-25295 : Subscriber is not allowed to dequeue buffered messages
  • ora-22616 : image is not of Oracle 8.1 format
  • ora-02214 : duplicate BACKUP option specification
  • ora-28362 : master key not found
  • ora-13484 : the file format and/or compression type is not supported
  • ora-39764 : specified stream is not in the specified direct path context
  • ora-02790 : File name is too long
  • ora-02032 : clustered tables cannot be used before the cluster index is built
  • ora-13338 : failure in reversing LRS polygon/collection geometry
  • ora-22140 : given size [string] must be in the range of 0 to [string]
  • ora-29875 : failed in the execution of the ODCIINDEXINSERT routine
  • ora-13423 : invalid cell coordinate parameter
  • ora-07208 : sfwfb: failed to flush dirty buffers to disk.
  • ora-22322 : error table "string"."string" has incorrect structure
  • 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.