Truncate question
This question probably is very simple for expert.
I invalid partition message when I use following truncate statements. However, if I use delete statement, then I don’t have problem. Please let me know. Thank you.
Either
l_string := 'ALTER TABLE XXXXX TRUNCATE PARTITION || l_part ';
or
l_string := 'ALTER TABLE XXXXX TRUNCATE PARTITION ('|| l_part || ')';
EXECUTE IMMEDIATE l_string;
l_string := 'DELETE FROM XXXXX PARTITION ('|| l_part || ')';
EXECUTE IMMEDIATE l_string;