title: Constraints error during partitions Drop
body: <p>When i am trying to drop partitions in oracle i am facing the below mentioned error.</p>
  
  <p>Error report:
  SQL Error: ORA-02266 -  "unique/primary keys in table referenced by enabled foreign keys"
  *Cause:    An attempt was made to truncate a table with unique or
             primary keys referenced by foreign keys enabled in another table.
             Other operations not allowed are dropping/truncating a partition of a
             partitioned table or an ALTER TABLE EXCHANGE PARTITION.
  *Action:   Before performing the above operations the table, disable the
             foreign key constraints in other tables. You can see what
             constraints are referencing a table by issuing the following
             command:
             SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = "tabnam";</p>
  
  <p>i have few system constraints and few developed by me so do i need to disable the system constraints also to drop partitions, attached is the screenshot of constraints.<a href="https://i.stack.imgur.com/epSUi.jpg" rel="nofollow noreferrer">enter image description here</a> </p>