Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

User Constraints

Status
Not open for further replies.

deschalk

Technical User
Jul 19, 2010
2
US
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?
 
Hi,
Are you connected as a SYSDBA ?

Who created the constraints?





[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
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.
 



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

To remove them use: PURGE RECYCLEBIN;
[3eyes]


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














 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top