ORA-22833: Must cast a transient type to a persistent type

Cause : An attempt was made to use the transient type in the query result.

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

Cast the transient type to a structurally equivalent persistent type.

update : 24-04-2017
ORA-22833

ORA-22833 - Must cast a transient type to a persistent type
ORA-22833 - Must cast a transient type to a persistent type

  • ora-37050 : (XSMLTDCL06) You cannot use the RELATION command with workspace object because analytic workspace string is attached in MULTI mode.
  • ora-08111 : a partitioned index may not be coalesced as a whole
  • ora-38621 : Decision Tree maximum depth setting not between [2, 20]
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-07242 : slembfn: translation error, unable to translate error file name.
  • ora-01483 : invalid length for DATE or NUMBER bind variable
  • ora-19808 : recovery destination parameter mismatch
  • ora-38772 : cannot add datafile 'string' - file could not be created
  • ora-19621 : archivelog range has already been specified
  • ora-00021 : session attached to some other process; cannot switch session
  • ora-00364 : cannot write header to new log member
  • ora-06042 : NETDNT: message receive failure
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-13019 : coordinates out of bounds
  • ora-01769 : duplicate CLUSTER option specifications
  • ora-31476 : a change table data column is missing from the source table
  • ora-00113 : protocol name string is too long
  • ora-30569 : data type of given column is not supported in a log group
  • ora-12170 : TNS:Connect timeout occurred
  • ora-37180 : expected exactly one column for dimension string, got string
  • ora-07454 : queue timeout, string second(s), exceeded
  • ora-07509 : scgfal: $deq parent lock unexpected return
  • ora-07758 : slemcw: invalid handle
  • ora-12719 : operation requires database is in RESTRICTED mode
  • ora-14404 : partitioned table contains partitions in a different tablespace
  • ora-01674 : data file string is an old incarnation rather than current file
  • ora-01060 : array binds or executes not allowed
  • ora-36836 : (XSLMGEN06) Dimension string.string!string hierarchy string level string is missing a PHYSICALNAME property value
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-06909 : CMX: error during acknowledge of ORACLE_SID
  • 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.