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 : 25-04-2017
ORA-12093

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

  • ora-02723 : osnpui: cannot send break signal
  • ora-32412 : encrypted column "string" not allowed in the materialized view log
  • ora-15190 : Internal ASM testing event number 15190
  • ora-01227 : log string is inconsistent with other logs
  • ora-14163 : subpartition number string: INITRANS value must be less than MAXTRANS value
  • ora-12689 : Server Authentication required, but not supported
  • ora-36179 : (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.
  • ora-23427 : deferred purge queue argument string out of range
  • ora-28025 : missing or null external name
  • ora-30682 : improper value for argument OPTION_FLAGS
  • ora-06138 : NETTCP: error during connection handshake
  • ora-13615 : The task or object string is greater than the maximum allowable length of 30 characters.
  • ora-02179 : valid options: ISOLATION LEVEL { SERIALIZABLE | READ COMMITTED }
  • ora-19011 : Character string buffer too small
  • ora-36221 : (XSLPDSC02) LIST number and LIST number have different base dimensions.
  • ora-01867 : the interval is invalid
  • ora-31023 : Index size error
  • ora-01573 : shutting down instance, no further change allowed
  • ora-02445 : Exceptions table not found
  • ora-31631 : privileges are required
  • ora-15079 : ASM file is closed
  • ora-19262 : XQ0042 - namespace constructor not inside an element constructor
  • ora-15106 : missing or invalid operating system disk locator string
  • ora-19646 : cannot change size of datafile string from string to string
  • ora-19200 : Invalid column specification
  • ora-28347 : encryption properties mismatch
  • ora-00359 : logfile group string does not exist
  • ora-31414 : error(s) occurred during change table advance
  • ora-07701 : sksatln: internal exception: output buffer too small
  • ora-00092 : LARGE_POOL_SIZE must be greater than LARGE_POOL_MIN_ALLOC
  • 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.