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-13372: failure in modifying metadata for a table with spatial index
ORA-02780: Name given for the core dump directory is invalid
ORA-07282: sksaprd: string overflow.
ORA-09789: sllfsk: unable to read file.
ORA-13707: Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.
PROC-00018: The value size passed is too large
ORA-00960: ambiguous column naming in select list
QSM-00757: the specified workload string is not referenced by task string
QSM-02072: requirements not satisfied for fast refresh of nested mv
ORA-19628: invalid SCN range
NNL-00561: register <name> [-t<type>] [-d<address>] [-h<hostname>] [-l<listener_name>] : register an object with Oracle Names
TNS-00095: * to trace_on - argument is considered the trace level