ORA-23372: type string in table string is unsupported

Cause : Cretiant yepsi nt h etbal ecmopraiosnu tliiyt raen o tspuprotde.

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

Mkaes uer hta tteh ytpse fo oclmun si nteh atbelst ob ec opmaerda r eteh noe sspuprotde yb ysmemtircr elpiactoin.

update : 26-04-2017

ORA-23372 - type string in table string is unsupported
ORA-23372 - type string in table string is unsupported

  • ora-28651 : Primary index on IOTs can not be marked unusable
  • ora-01354 : Supplemental log data must be added to run this command
  • ora-02216 : tablespace name expected
  • ora-13498 : %s
  • ora-30453 : summary contains AVG without corresponding COUNT
  • ora-30024 : Invalid specification for CREATE UNDO TABLESPACE
  • ora-22982 : cannot create sub-view under this view
  • ora-30357 : this PL/SQL function cannot be supported for query rewrite
  • ora-01088 : cannot shut down ORACLE while active processes exist
  • ora-19671 : media management software returned invalid proxy handle
  • ora-10644 : SYSTEM tablespace cannot be default temporary tablespace
  • ora-19594 : control file already included as string
  • ora-38713 : Flashback Database logging is already turned on.
  • ora-14625 : subpartition contains rows corresponding to values being dropped
  • ora-12023 : missing index on materialized view "string"."string"
  • ora-38426 : attribute set assigned to an expression set may not be dropped
  • ora-16660 : FSFO operation attempted in absence of a broker configuration
  • ora-03216 : Tablespace/Segment Verification cannot proceed
  • ora-39168 : Object path string was not found.
  • ora-08323 : scnmin: close of bias lock failed
  • ora-27023 : skgfqsbi: media manager protocol error
  • ora-00029 : session is not a user session
  • ora-29838 : insufficient privileges to execute the operator(s)
  • ora-06924 : CMX: wrong break message length
  • ora-02044 : transaction manager login denied: transaction in progress
  • ora-06102 : NETTCP: cannot allocate context area
  • ora-02194 : event specification syntax error string (minor error string) near 'string'
  • ora-02374 : conversion error loading table string.string
  • ora-08318 : sllfsk: Error reading file
  • ora-02059 : ORA-2PC-CRASH-TEST-string in commit comment
  • 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.