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



Government Jobs Opening


...