Oracle Invalid Objects

The definitions of some objects, including views and procedures, reference other objects, such as tables.
As a result, the objects being defined are dependent on the objects referenced in their definitions. 

First check all the INVALID objects in the schema using :

select OBJECT_NAME,OBJECT_TYPE from user_objects where status='INVALID';

compile the objects accordingly....

ALTER PACKAGE my_package COMPILE;
ALTER PACKAGE my_package COMPILE BODY;
ALTER PROCEDURE my_procedure COMPILE;
ALTER FUNCTION my_function COMPILE;
ALTER TRIGGER my_trigger COMPILE;
ALTER VIEW my_view COMPILE;


 Oracle Errors
Oracle Errors and their explanations
Oracle Invalid Objects
Oracle Softwares & Tools

 Frequently asked oracle errors
  • ORA-19502:write error on file "string", blockno string (blocksize=string)
  • ORA-28001:the password has expired
  • ORA-24033:no recipients for message
  • ORA-12152:TNS:unable to send break message
  • ORA-21561:OID generation failed
  • ORA-01144:File size (string blocks) exceeds maximum of string blocks
  • ORA-01086:savepoint 'string' never established
  • ORA-12712:new character set must be a superset of old character set
  • ORA-00824:cannot set sga_target due to existing internal settings, see alert log for more information
  • ORA-19804:cannot reclaim string bytes disk space from string limit
  • ORA-01610:recovery using the BACKUP CONTROLFILE option must be done
  • ORA-16224:Database Guard is enabled
  • ORA-00600:internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ORA-12853:insufficient memory for PX buffers: current stringK, max needed stringK
  • ORA-02069:global_names parameter must be set to TRUE for this operation
  • ORA-00027:cannot kill current session
  • ORA-01732:data manipulation operation not legal on this view
  • ORA-21780:Maximum number of object durations exceeded.
  • ORA-01149:cannot shutdown - file string has online backup set
  • ORA-01190:control file or data file string is from before the last RESETLOGS
  • Main Page      Contact Us