Tuesday, February 7, 2012
Give me the situation where truncate is not allowed on a table in oracle?
You cannot truncate the parent table of an enabled foreign key constraint. You must disable the constraint before truncating the table. An exception is that you can truncate the table if the integrity constraint is self-referential.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment