Organizational Research By

Surprising Reserch Topic

truncate table in oracle getting errors


truncate table in oracle getting errors  using -'sql,oracle,plsql'

I got the problem is when I run following command in Oracle, I encounter the error.

Truncate table mytable;


Errors:

ORA-02266: unique/primary keys in table referenced by enabled foreign keys


I found that, this mytable has relationship with other tables. That's why Truncate command cannot proceed anymore. How to delete data from myTable with the SQL scripts using Truncate command?
    

asked Oct 3, 2015 by vijayshukla80
0 votes
33 views



Related Hot Questions

5 Answers

0 votes
NULL
answered Oct 3, 2015 by manju bhargava
0 votes
NULL
answered Oct 3, 2015 by okesh.badhiye
0 votes
NULL
answered Oct 3, 2015 by sanjaypal1983
0 votes
NULL
answered Oct 3, 2015 by tejas lakhani
0 votes
NULL
answered Oct 3, 2015 by dahiyabecomp

...