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 Sep 30, 2015 by atulpariharmca
0 votes
39 views



Related Hot Questions

5 Answers

0 votes
NULL
answered Sep 30, 2015 by abhimca2006
0 votes
NULL
answered Sep 30, 2015 by android_master
0 votes
NULL
answered Sep 30, 2015 by kotmus2002
0 votes
NULL
answered Sep 30, 2015 by dhananjayksharma
0 votes
NULL
answered Sep 30, 2015 by ankitarajoria4

...