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-01345: Supplemental log data must be enabled to build into the logstream
ORA-14277: tables in EXCHANGE SUBPARTITION must have the same number of columns
ORA-36666: (XSDPART04) workspace object is not a concat dimension.
ORA-16402: ONDEMAND archival requires FAL_CLIENT and FAL_SERVER support
TNS-00204: Started tracing in intlsnr
LFI-00143: Unable to delete non-existent file string.
KUP-04074: no write access to directory object string
ORA-16081: insufficient number of processes for APPLY
ORA-25197: an overflow segment already exists for the indexed-organized table
ORA-22851: invalid CHUNK LOB storage option value
RMAN-02007: Integer value overflow
ORA-28237: seed length too short