drop type - force option
I have dropped all the dependent objects on the type i found and tried to drop the type where i got an error saying that still i have some dependent objects
so I have dropped the type using force option. Big mistake!!!!!
There is a dependent table which i forgot to drop before dropping the type ...
Now i need to drop and recreate this dependent table ..which became invaid now
I am not able to drop it now ... error is ::
ORA-00604: error occurred at recursive SQL level 1 ORA-04063: table "xyz" has errors
even i recreated the type .. but still the table is invalid ..
my questions are :
1.Is there any way where i can know all the dependent objects on particular type?
2.How to drop the invalid objects .. in this case how to drop my table ..?