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-01904: DATAFILE keyword expected
ORA-13043: failed to read metadata from the <layer>_SDOLAYER table
PROC-00019: Cannot create more subkeys for the key
ORA-23494: too many rows for destination "string"
SQL*Loader-00942: partition string not part of table string
PCC-02405: Variable is of undefined type
NNL-00530: quit|exit : exit the names control program
DRG-11422: linguistic initialization failed
ORA-39055: invalid bad file specification.
LCD-00161: ORACLE error (possible syntax error) parameter [string]
NNF-00001: Not a TNS address
DGM-16906: Unable to accept commands: no memory