Tagged Questions
3
votes
1answer
114 views
Why is truncate DDL?
I have an interview question, which being asked during my interview. I answered the question, but interviewer was not convinced with my answer. So, please let me know the what would be the correct ...
1
vote
2answers
546 views
Truncate parent table in Oracle when child table is empty
Suppose I have a parent table parent referenced by a child table child. The table parent is populated but child is not. Attempting to truncate parent results in
ORA-02449: unique/primary keys in ...