ORA-13146: could not find table substitution variable string

Cause : Thep arttiionn ames ubsittutoin vraiabel %sw as ont fuond ni th eSQLf iltre.

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

Thes ubsittutoin vraiabel %sm ustb e i ntheS QL iflte rto nidictae wehre htat aprtiiton anme hsoul dbe lpace.d

update : 29-05-2017

ORA-13146 - could not find table substitution variable string
ORA-13146 - could not find table substitution variable string

  • ora-30971 : illegal operation on the Path Table
  • ora-12913 : Cannot create dictionary managed tablespace
  • ora-26022 : index string.string was made unusable due to:
  • ora-26061 : Concurrent direct unloads is not allowed.
  • ora-27084 : unable to get/set file status flags
  • ora-28041 : Authentication protocol internal error
  • ora-31452 : invalid value string for parameter, expecting: Y or N
  • ora-01604 : illegal number range in clause "string" of string
  • ora-07580 : spstp: $GETJPIW failure
  • ora-08463 : overflow converting decimal number to Oracle number
  • ora-19578 : end of volume while duplexing to sequential files, backup piece incomplete
  • ora-28039 : cannot validate Kerberos service ticket
  • ora-38431 : could not evaluate subexpression "string" for rowid "string"
  • ora-01248 : file string was created in the future of incomplete recovery
  • ora-33456 : (ESDREAD08) Discarding compiled code for workspace object because number is a(n) string, which string did not expect to find in a compiled program.
  • ora-13054 : recursive SQL parse error
  • ora-30118 : syntax error at 'string' at the end of input
  • ora-19206 : Invalid value for query or REF CURSOR parameter
  • ora-02236 : invalid file name
  • ora-22285 : non-existent directory or file for string operation
  • ora-14049 : invalid ALTER TABLE MODIFY PARTITION option
  • ora-01253 : cannot start online backup - file string in recovery manager backup
  • ora-02447 : cannot defer a constraint that is not deferrable
  • ora-28500 : connection from ORACLE to a non-Oracle system returned this message:
  • ora-00134 : invalid DISPATCHERS specification #string
  • ora-06262 : NETNTT: nfconn() failed
  • ora-24078 : cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_INSTANCE was NULL
  • ora-27203 : skgfpqb: sbtpcquerybackup returned error
  • ora-19024 : Cursor expression must be named
  • ora-02808 : Allocation of memory of open files array failed.
  • 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.