Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

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?

asked Sep 30, 2015 by mcasudhir
0 votes

Related Hot Questions

Government Jobs Opening