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 |
O2I-00116: Unable to close the HFILE file
DRG-11503: insert statement overflows maximum statement size
PCB-00228: Invalid group item variable "string"
LSX-00144: attribute "~1S" invalid derivation-restriction value "~2S"
LPX-00301: error in XPATH evaluation
TNS-00230: Cannot start new pump process: string string Protocol Adapter errors:number
ORA-14503: only one partition name can be specified
ORA-09926: Unable to set effective privilege set of the server
NPL-00300: maximum ASN.1 element nesting depth string exceeded on read
QSM-02116: mupltiple master sites
RMAN-08543: channel string: specifying archivelog(s) for proxy backup
TNS-02501: Authentication: no more roles