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



Government Jobs Opening


...