Truncate partion table
539393Jan 27 2009 — edited Jan 29 2009Hi everyone! I have this problem: I have a partioned table with 2 field that are nested table (simple fields, not in primary key, not fields of partition range and not partioned nested table) . I have no problem if I truncate the entire table, but I can't truncate a specific partion because the nested tables foreign key.
Is there a command that I can use to perform this gain or this is a limit in use of nested tables?
Thank you very much in advance for your answer,
Nadia