ORA-24158: invalid table alias

Cause : tbal eaila snmaeo rb aes atbel anm ei snto pseicfeidi nt h etbal eaila sdfeiintno

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

sepcfiyb oht laisa anm eadn laisa abs etbal ei nteh atbel laisa tsrcutrue

update : 30-04-2017
ORA-24158

ORA-24158 - invalid table alias
ORA-24158 - invalid table alias

  • ora-30395 : dimension options require the COMPATIBLE parameter to be string or greater
  • ora-36188 : (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.
  • ora-19734 : wrong creation SCN - control file expects converted plugged-in datafile
  • ora-09978 : skxfqhdel: Error Disconnecting from another endpoint.
  • ora-30150 : Invalid argument passed to OCIFile function
  • ora-31115 : XDB configuration error: string
  • ora-25229 : error on transformation of message string string
  • ora-01273 : STANDBY_FILE_MANAGEMENT = AUTO needs COMPATIBLE = string or higher
  • ora-30972 : invalid ALTER INDEX option for XML Index
  • ora-27250 : OS system call failure
  • ora-01752 : cannot delete from view without exactly one key-preserved table
  • ora-00359 : logfile group string does not exist
  • ora-31182 : Too many PL/SQL DOM handles specified
  • ora-02204 : ALTER, INDEX and EXECUTE not allowed for views
  • ora-32135 : Cannot assign FILEs
  • ora-38479 : creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed
  • ora-31069 : Cannot apply typed changes to non-schema-based XMLType nodes
  • ora-13192 : failed to read number of element rows
  • ora-01343 : LogMiner encountered corruption in the logstream
  • ora-39103 : Timeout before worker process string finished initialization. Worker error:
  • ora-30733 : cannot specify rowid constraint on scoped ref column
  • ora-01179 : file string does not exist
  • ora-28339 : missing or invalid encryption algorithm
  • ora-31029 : Cannot bind to unsaved resource
  • ora-37121 : AW Spreadsheet invalidated
  • ora-24203 : operation failed, queue table string.string has errors
  • ora-06742 : TLI Driver: cannot alloc t_bind
  • ora-39122 : Unprivileged users may not perform string remappings.
  • ora-22055 : unknown sign flag value [string]
  • ora-27451 : %s cannot be NULL
  • 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.