Pre Exam Test Practice
Ask a Question
Advertise on boostr.in
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;
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?
Oct 3, 2015
to add a comment.
Related Hot Questions
Government Jobs Opening