Deleting the Records After Disable the Constraints.

By: Sugandh | 12 Jun 2015 5:53 pm | 0 Comments

Hello Experts,

I need a clarification on oracle table constraints enable and disable. I have a big table and I am deleting the records after disable the constraints. After delete I want to enable those constraints.

Will this take much time to enable constraints?

Kindly assist, thanks in advance.

Comments

No Comments Posted for this Article.

Termination and Disable Deactivated User
Oracle SQL Questions for Oracle Certified Professional Exams IZ007
Disable SQL Trace level ALL_WITH_RESULTS in HANA
Load Data from SQL Server 2000 to Oracle 11g Regularly
DB Connect, Native SQL, Query external Oracle??
Which statement is true regarding enabling constraints?
Which SQL statement defines a FOREIGN KEY constraint on the DEPT NO column of the EMP table?
Recursively Fetch the Records in SQL Server Or in Cognos
Database operations recorded in the SQL cache (M_SQL_PLAN_CACHE)
Remove Reviewer button disabled after adding an Adhoc Reviewer Agent

ASK US !

Get solutions from our experts!

Deleting the Records After Disable the Constraints.

Forums