ORA-21708: inappropriate operation on a transient object

Cause : Usre attemtpedt o eprfrom na ianpporpraiteo peartino o na rtanisen tobejct .Opreatoinst ha tcannotb e papleid ot at rasnietn ojbec tinlcud eflsuhign adn lcokign.

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

Usre sohul daviod eprfromign scuh poertaio nona tarnseinto bjcet.

update : 25-04-2017

ORA-21708 - inappropriate operation on a transient object
ORA-21708 - inappropriate operation on a transient object

  • ora-26675 : cannot create Streams capture process string
  • ora-00363 : log is not the archived version
  • ora-13844 : no new SQL profile name or category specified.
  • ora-31121 : The string operator can not be FALSE
  • ora-24168 : rule string.string cannot have default evaluation context
  • ora-16094 : database shutdown during archival operation
  • ora-29327 : unsupported client compatibility mode used when talking to the server
  • ora-16635 : NetSlave connection was broken in the middle of a transmission session
  • ora-23310 : object group "string"."string" is not quiesced
  • ora-00487 : CTWR process terminated with error
  • ora-37121 : AW Spreadsheet invalidated
  • ora-00052 : maximum number of enqueue resources (string) exceeded
  • ora-02206 : duplicate INITRANS option specification
  • ora-22315 : type "string" does not contain a map or order function
  • ora-06545 : PL/SQL: compilation error - compilation aborted
  • ora-26761 : Standby Redo Logs not available for real time mining
  • ora-13211 : failed to tessellate the window object
  • ora-15059 : invalid device type for ASM disk
  • ora-09351 : Windows 32-bit Two-Task driver unable to allocate shared memory
  • ora-23464 : flavor lacks column string of "string"."string"
  • ora-31003 : Parent string already contains child entry string
  • ora-30401 : JOIN KEY columns must be non-null
  • ora-28668 : cannot reference mapping table of an index-organized table
  • ora-07477 : scgcmn: lock manager not initialized.
  • ora-28539 : gateway does not support result sets
  • ora-07742 : slemop: $CONNECT failure
  • ora-13632 : The user cancelled the current operation.
  • ora-15010 : name is already used by an existing ASM disk
  • ora-01031 : insufficient privileges
  • ora-00086 : user call does not exist
  • 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.