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...
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?
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.