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-14039: partitioning columns must form a subset of key columns of a UNIQUE index
ORA-19587: error occurred reading string bytes at block number string
NNL-00557: Causes the controller to sleep for N seconds
QSM-01027: materialized view, string, is unusable
PROT-00018: Failed to open file
ORA-08206: ora_addr: cannot translate address file name
SQL*Loader-00402: Unable to determine length of column string from specification
ORA-02494: invalid or missing maximum file size in MAXSIZE clause
ORA-30567: name already used by an existing log group
ORA-02459: Hashkey value must be a positive integer
ORA-15074: diskgroup string requires rebalance completion
PLS-00359: assignment target in 'string' must have components