ORA-30558: internal error [string] in function based index

Cause : hTsii snai tnrean lreor.r

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

oCtnca toWlrwddi eusppro tiwhtt ehe axtce rrrot xe.t

update : 24-05-2017
ORA-30558

ORA-30558 - internal error [string] in function based index
ORA-30558 - internal error [string] in function based index

  • ora-18003 : an outline already exists with this signature
  • ora-00090 : failed to allocate memory for cluster database ORADEBUG command
  • ora-03008 : parameter COMPATIBLE >= string needed for string
  • ora-31513 : unsupported column type specified in change table
  • ora-22332 : a dependent object in schema "string" has errors. string
  • ora-24407 : connection pool already exists
  • ora-06514 : PL/SQL: The remote call cannot be handled by the server
  • ora-02775 : Invalid request done signal
  • ora-30082 : datetime/interval column to be modified must be empty to decrease fractional second or leading field precision
  • ora-12609 : TNS: Receive timeout occurred
  • ora-24096 : invalid message state specified
  • ora-02879 : sou2o: Could not gain access to protected memory
  • ora-24148 : cannot drop rule string.string with dependents
  • ora-14023 : creation of GLOBAL partitioned cluster indices is not supported
  • ora-06601 : LU6.2 Driver: Invalid database ID string
  • ora-06755 : TLI Driver: cannot close transport endpoint
  • ora-25457 : evaluation function string returns failure
  • ora-16016 : archived log for thread string sequence# string unavailable
  • ora-04033 : Insufficient memory to grow pool
  • ora-26708 : remote DDL not supported by STREAMS : dblink string
  • ora-30086 : interval year-month result not allowed for datetime subtraction
  • ora-06413 : Connection not open.
  • ora-09914 : Unable to open the ORACLE password file.
  • ora-12091 : cannot online redefine table "string"."string" with materialized views
  • ora-27087 : unable to get share lock - file not readable
  • ora-24230 : input to DBMS_DDL.WRAP is not a legal PL/SQL unit
  • ora-38479 : creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed
  • ora-19854 : error obtaining connect string from target
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-13236 : internal error in R-tree processing: [string]
  • 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.