Disable all table constraints in Oracle

1124240 pts.
Tags:
Oracle
Oracle Table
Would I be able to disable all the table constraints in Oracle using one single command? It doesn't matter what table it is. It can be for a a single table, list of tables or for all tables. Thanks so much!
1

Answer Wiki

Thanks. We'll let you know when a new response is added.
Hi,
Please navigate here to overcome this issue: http://oracle.ittoolbox.com/documents/how-to-disable-all-constraints-via-single-sql-command-18449 I hope it will assist you in resolving issues.
Thanks & Regards
Clark Kent

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Brijesh
    Hi,

    Try the below query hope this helps

    1) ALTER TABLE table_name
    DISABLE CONSTRAINT constraint_name;

    2) ALTER TABLE table_name
    ENABLE CONSTRAINT constraint_name;

    14,450 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: