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-14255: table is not partitioned by Range, Composite Range or List method
ORA-00152: current session does not match requested session
DRG-10511: index string does not exist or is incomplete
ORA-30730: referential constraint not allowed on nested table column
ORA-06529: Version mismatch - PL/SQL profiler
ORA-26091: requested direct path operation not supported
ORA-12454: label string does not exist for policy string
ORA-26717: SCN limit reached
ORA-19657: cannot inspect current datafile string
ORA-13040: failed to subdivide tile
ORA-39054: missing or invalid definition of the SQL output file.
QSM-01115: rollup took place on a column with a window function