Is there a way to drop constraints if the tables have already been dropped and 'delete all_constraints;' returns error message - ORA-01031: insufficient privileges?
No, I don't have the sysdba password. It's an academic server and I'm just one instance out of many. I created the tables. I also dropped them before I realized it would leave behind the constraints and indexes. Now, I have a mess of them and they all start with bin... My professor and I have been trying to figure this out for a few days. We have a call into a DBA, but he has not gotten back to us yet.
----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
And constraints and indexes on a table are also dropped when you drop the table.
You really should NOT try to use DML on data dictionary views/tables - you stand an excellent chance of fouling up your database to the point of non-usability.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.