ORA-24439: success with PLSQL compilation warning

Cause : A plsql compilation warning occurred.

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

Return OCI_SUCCESS_WITH_INFO along with the error code.

update : 25-04-2017

ORA-24439 - success with PLSQL compilation warning
ORA-24439 - success with PLSQL compilation warning

  • ora-27043 : unable to seek to beginning of file
  • ora-29741 : IMR active for some, but not all members of cluster
  • ora-25176 : storage specification not permitted for primary key
  • ora-22053 : overflow error
  • ora-19374 : invalid staging table
  • ora-39117 : Type needed to create table is not included in this operation. Failing sql is: string
  • ora-37016 : (XSACQUIRE01) You must specify objects to acquire for the ACQUIRE command.
  • ora-22614 : error while construction the collection in the image
  • ora-29530 : could not create shortened name for string
  • ora-13868 : Instance-wide SQL tracing on instance string is not enabled
  • ora-06748 : TLI Driver: cannot allocate t_discon
  • ora-01646 : tablespace 'string' is not read only - cannot make read write
  • ora-16758 : the specified apply instance is not running
  • ora-38480 : creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.
  • ora-01344 : LogMiner coordinator already attached
  • ora-31494 : could not activate a LogMiner session
  • ora-06548 : no more rows needed
  • ora-07256 : sptrap: cannot set up signal handler to catch exceptions.
  • ora-31023 : Index size error
  • ora-09989 : attempt to use invalid skgmsdef struct pointer
  • ora-12721 : operation cannot execute when other sessions are active
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-26078 : file "string" is not part of database being loaded
  • ora-14053 : illegal attempt to modify string in string statement
  • ora-14314 : resulting List partition(s) must contain atleast 1 value
  • ora-06134 : NETTCP: file access privilege violation
  • ora-16075 : standby database destination mismatch
  • ora-07634 : smsdbp: $CRETVA failure
  • ora-02052 : remote transaction failure at string
  • ora-22633 : Error freeing AnyDataSet
  • 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.