ORA-24372: invalid object for describe
Answers were Sorted based on User's Feedback
Answer / guest
Cause: The object to be described is not valid. It either
has compilation or authorization errors.
Action: The object to be described must be valid.
Please add more information about this Error
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / santosh kumar
Use This query to find out any invalid objects with the same Object name in error.
select object_name,owner,object_type,status
from all_objects
where object_name=&object_in_error;
Then try to compile the invalid objects
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-30747: cannot create substitutable tables or columns of non final type string.string
RMAN-06157: validation failed for archived log
SQL*Loader-00422: constant element count of number for column string is greater than maximum, number
ORA-00367: checksum error in log file header
ORA-22327: cannot change a type to NOT INSTANTIABLE if it has dependent tables
LSX-00340: improper namespace value for the imported element
NNO-00123: node "string" has no authoritative parent, data ignored
NZE-28846: No private key
TNS-00081: * trace_on - ask process name to turn tracing on
ORA-06106: NETTCP: socket creation failure
ORA-00084: global area must be PGA, SGA, or UGA
ORA-16755: failed to set initialization parameter