Yesterday, we discussed merging and splitting multiple partitions. The same feature is extended in 12c to add, drop or truncate multiple partitions in a single SQL statement.<\/p>\n
Add multiple partitions example:<\/p>\n
ALTER TABLE SALESDATA ADD\nPARTITION S2015Q1 VALUES LESS THAN (TO_DATE('01-APR-15','DD-MON-YY')),\nPARTITION S2015Q2 VALUES LESS THAN (TO_DATE('01-JUL-15','DD-MON-YY')),\nPARTITION S2015Q3 VALUES LESS THAN (TO_DATE('01-OCT-15','DD-MON-YY')),\nPARTITION S2015Q4 VALUES LESS THAN (TO_DATE('01-JAN-16','DD-MON-YY'));<\/pre>\nRead more in Oracle Documentation<\/a><\/p>\n <\/p>\n
Truncate multiple partitions example:<\/p>\n
ALTER TABLE SALESDATA TRUNCATE PARTITIONS \nS2001Q1, S2001Q2, S2001Q3, S2001Q4;<\/pre>\nRead more in Oracle Documentation<\/a><\/p>\n <\/p>\n
Drop multiple partitions example:<\/p>\n
ALTER TABLE SALESDATA DROP PARTITIONS\u00a0\nS2001Q1, S2001Q2, S2001Q3, S2001Q4;<\/pre>\nRead more in Oracle Documentation<\/a><\/p>\n <\/p>\n
<\/p>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Yesterday, we discussed merging and splitting multiple partitions. The same feature is extended in 12c to add, drop or truncate multiple partitions in a single SQL statement. Add multiple partitions example: ALTER TABLE SALESDATA ADD PARTITION S2015Q1 VALUES LESS THAN (TO_DATE(’01-APR-15′,’DD-MON-YY’)), PARTITION S2015Q2 VALUES LESS THAN (TO_DATE(’01-JUL-15′,’DD-MON-YY’)), PARTITION S2015Q3 VALUES LESS THAN (TO_DATE(’01-OCT-15′,’DD-MON-YY’)), PARTITION S2015Q4 … Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[133],"tags":[40,60],"class_list":["post-139","post","type-post","status-publish","format-standard","hentry","category-oracledb","tag-oracle-12c","tag-partition"],"acf":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/139","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/comments?post=139"}],"version-history":[{"count":1,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/139\/revisions"}],"predecessor-version":[{"id":3032,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/posts\/139\/revisions\/3032"}],"wp:attachment":[{"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/media?parent=139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/categories?post=139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bijoos.com\/oraclenotes\/wp-json\/wp\/v2\/tags?post=139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}