User Constraints

[deschalk]

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?

 

[Turkbear]

Hi,
Are you connected as a SYSDBA ?

Who created the constraints?







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[deschalk]

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.

 

[LKBrwnDBA]

Objects starting with "BIN$" are drop'ped objects in the re-cycle bin.

To remove them use: PURGE RECYCLEBIN;



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[carp]

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.

 

[Beilstwh]

As CARP said, when a table is dropped, ALL indexes and constraints are dropped along with it. They may be in the Recycle bin, but they are gone.

Bill
Lead Application Developer
New York State, USA