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-09-2017

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

  • ora-00298 : Missing or invalid attribute value
  • ora-14629 : cannot drop the only subpartition of a partition
  • ora-14125 : REVERSE/NOREVERSE may not be specified in this context
  • ora-06735 : TLI Driver: client failed to close error conn
  • ora-19927 : CONVERT DATABASE operation cannot proceed
  • ora-19261 : XQ0041 - non empty URI in QName
  • ora-07565 : sldext: $SEARCH failure
  • ora-07411 : slgfn: full path name too big for supplied buffer.
  • ora-24150 : evaluation context string.string does not exist
  • ora-37133 : (XSCCOMP08) You cannot write into an aggregated VARIABLE dimensioned by a COMPRESSED COMPOSITE. Use the CLEAR AGGREGATES command to reenable write access.
  • ora-17611 : ksfd: file 'string' cannot be accessed, global open closed
  • ora-29547 : Java system class not available: string
  • ora-02363 : error reading from file: string
  • ora-25291 : Buffer does not exist for the specified queue
  • ora-16958 : DML statements running parallel are not supported for test execute.
  • ora-06443 : ssvpstev: Incorrect parameter passed to function call
  • ora-00237 : snapshot operation disallowed: control file newly created
  • ora-23413 : table "string"."string" does not have a materialized view log
  • ora-02356 : The database is out of space. The load cannot continue
  • ora-13119 : invalid edge_id [string]
  • ora-23393 : the user is already the propagator
  • ora-38426 : attribute set assigned to an expression set may not be dropped
  • ora-32735 : DIAG process is not running in the instance
  • ora-38445 : TOP clause not allowed with no statistics
  • ora-24197 : JAVA stored procedure throws JAVA exceptions
  • ora-39093 : FLASHBACK automatically enabled to preserve database integrity.
  • ora-01653 : unable to extend table string.string by string in tablespace string
  • ora-09829 : pw_createPorts: server call pws_start_instance failed.
  • ora-10647 : Tablespace other than SYSTEM, string, string not found in read only mode
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • 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.