ORA-12093: invalid interim table "string"."string"

Cause : The talbe is nto the itnerim tbale of hte corrsepondin gtable ot be onilne redfeined.

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

Pass i nthe vaild inteirm tabl.e

update : 24-07-2017
ORA-12093

ORA-12093 - invalid interim table "string"."string"
ORA-12093 - invalid interim table "string"."string"

  • ora-29935 : missing FROM keyword
  • ora-06916 : CMX: error in data read (t_datain)
  • ora-09915 : Password encryption failed.
  • ora-16191 : Primary log shipping client not logged on standby
  • ora-31627 : API call succeeded but more information is available
  • ora-16198 : Timeout incurred on internal channel during remote archival
  • ora-28029 : could not authorize remote server for user string
  • ora-29514 : class name contains illegal character
  • ora-23438 : missing refresh group template
  • ora-30569 : data type of given column is not supported in a log group
  • ora-12027 : duplicate filter column
  • ora-31070 : Invalid database user ID string
  • ora-00236 : snapshot operation disallowed: mounted control file is a backup
  • ora-32335 : dimension must have at least one level
  • ora-06517 : PL/SQL: Probe error - string
  • ora-28115 : policy with check option violation
  • ora-22150 : variable-length array has not been initialized
  • ora-28500 : connection from ORACLE to a non-Oracle system returned this message:
  • ora-32336 : cannot use USING NO INDEX to create materialized view "string"."string"
  • ora-28671 : UPDATE BLOCK REFERENCES may not be used on a partitioned index as a whole
  • ora-16092 : dependent archive log destination is not active
  • ora-32334 : cannot create prebuilt materialized view on a table already referenced by a MV
  • ora-01147 : SYSTEM tablespace file string is offline
  • ora-02091 : transaction rolled back
  • ora-00216 : control file could not be resized for migration from 8.0.2
  • ora-16574 : switchover disallowed when required databases are offline
  • ora-30381 : REWRITE_TABLE is not compatible with Oracle version
  • ora-22992 : cannot use LOB locators selected from remote tables
  • ora-32333 : disable table scn update for Materialized view
  • ora-02064 : distributed operation not supported
  • 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.