{"id":2675,"date":"2017-06-19T09:30:10","date_gmt":"2017-06-19T12:30:10","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=2675\/"},"modified":"2017-06-19T09:30:10","modified_gmt":"2017-06-19T12:30:10","slug":"ocm-12c-preparation-create-partitioned-tables","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/","title":{"rendered":"OCM 12c Preparation &#8211; Create partitioned tables"},"content":{"rendered":"<p>This topic is very similar with the one we had for <a href=\"https:\/\/www.dbarj.com.br\/en\/2015\/04\/ocm-11g-preparation-administer-partitioned-tables-and-indexes-using-appropriate-methods-and-keys\/\">OCM 11g<\/a> but here we need to consider not only all the partitioned methods that we had in 11g but also the new features regarding partitioned table in 12c.<\/p>\n<p>So practice here:<\/p>\n<ul>\n<li>Basic Partitioning Strategies: RANGE, LIST and HASH.<\/li>\n<li>Advanced\u00a0Partitioning Strategies: REFERENCE, INTERVAL, SYSTEM and\u00a0VIRTUAL COLUMN-BASED.<\/li>\n<li>Composite Partitions (all the combinations)<\/li>\n<li>Multicolumns Partitions (This is not composite!)<\/li>\n<li>Creating Partitioned Index-Organized Tables<\/li>\n<\/ul>\n<p>Plus:<\/p>\n<ul>\n<li>Partition Maintenance Operations on Multiple Partitions<\/li>\n<li>Partial Indexes for Partitioned Tables<\/li>\n<li>Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION<\/li>\n<li>Interval-Reference Partitioning<\/li>\n<li>Cascade Functionality for TRUNCATE PARTITION and EXCHANGE PARTITION<\/li>\n<li>Online Move Partition<a href=\"file:\/\/\/C:\/Users\/rodrigo.de.a.jorge\/Desktop\/OCM%2012c\/121\/E50529_01\/VLDBG\/GUID-C7A9BAD4-E4C9-4765-88C5-51AC7E97BAF1.htm#GUID-3070B501-1922-469F-B429-12D42574DE5C\"><\/a><\/li>\n<\/ul>\n<p><strong>Path to Documentation<\/strong>:<\/p>\n<p><span style=\"color: #800000;\">Database SQL Language Reference -&gt; CREATE TABLE<\/span><br \/>\n<span style=\"color: #800000;\"> VLDB and Partitioning Guide -&gt; 4 Partition Administration -&gt; Creating Partitions <strong>\u2013 (Good for copy paste examples during the exam)<\/strong><\/span><br \/>\n<span style=\"color: #800000;\"> VLDB and Partitioning Guide -&gt; 2 Partitioning Concepts<\/span><\/p>\n<br>\r\nClick here to go back to the <a title=\"OCM 12c Preparation\" href=\"\/?page_id=2255\">Main OCM 12c Preparation<\/a> page.\r\n<br><br>\r\nHave you enjoyed? Please leave a comment or give a \ud83d\udc4d!\n<div class='watch-action'><div class='watch-position align-left'><div class='action-like'><a class='lbg-style2 like-2675 jlk' href='javascript:void(0)' data-task='like' data-post_id='2675' data-nonce='de4404f630' rel='nofollow'><img class='wti-pixel' src='https:\/\/www.dbarj.com.br\/wp-content\/plugins\/wti-like-post\/images\/pixel.gif' title='Like' \/><span class='lc-2675 lc'>0<\/span><\/a><\/div><\/div> <div class='status-2675 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>This topic is very similar with the one we had for OCM 11g but here we need to consider not only all the partitioned methods that we had in 11g but also the new features regarding partitioned table in 12c. So practice here: Basic Partitioning Strategies: RANGE, LIST and HASH. Advanced\u00a0Partitioning Strategies: REFERENCE, INTERVAL, SYSTEM &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/\">Continue reading<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"class_list":["post-2675","post","type-post","status-publish","format-standard","hentry","category-ocm12c-en","item-wrap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>OCM 12c Preparation - Create partitioned tables - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Create partitioned tables for Oracle OCM 12c Certification\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DBA RJ\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-partitioned-tables\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-partitioned-tables\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"OCM 12c Preparation &#8211; Create partitioned tables\",\"datePublished\":\"2017-06-19T12:30:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-partitioned-tables\\\/\"},\"wordCount\":159,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"OCM 12c Preparation\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-partitioned-tables\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-partitioned-tables\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-partitioned-tables\\\/\",\"name\":\"OCM 12c Preparation - Create partitioned tables - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2017-06-19T12:30:10+00:00\",\"description\":\"Create partitioned tables for Oracle OCM 12c Certification\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-partitioned-tables\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-partitioned-tables\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2017\\\/06\\\/ocm-12c-preparation-create-partitioned-tables\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OCM 12c Preparation - Create partitioned tables\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\",\"name\":\"DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"description\":\"Blog about Databases, Security and High Availability\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\",\"name\":\"DBA RJ\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"contentUrl\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\",\"width\":712,\"height\":712,\"caption\":\"DBA RJ\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/wp-content\\\/uploads\\\/2019\\\/09\\\/RodrigoJorgePOUG19.png\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"OCM 12c Preparation - Create partitioned tables - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Create partitioned tables for Oracle OCM 12c Certification","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/","twitter_misc":{"Written by":"DBA RJ","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"OCM 12c Preparation &#8211; Create partitioned tables","datePublished":"2017-06-19T12:30:10+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/"},"wordCount":159,"commentCount":1,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["OCM 12c Preparation"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/","url":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/","name":"OCM 12c Preparation - Create partitioned tables - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2017-06-19T12:30:10+00:00","description":"Create partitioned tables for Oracle OCM 12c Certification","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2017\/06\/ocm-12c-preparation-create-partitioned-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"OCM 12c Preparation - Create partitioned tables"}]},{"@type":"WebSite","@id":"https:\/\/www.dbarj.com.br\/en\/#website","url":"https:\/\/www.dbarj.com.br\/en\/","name":"DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Blog about Databases, Security and High Availability","publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbarj.com.br\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9","name":"DBA RJ","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","url":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","contentUrl":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png","width":712,"height":712,"caption":"DBA RJ"},"logo":{"@id":"https:\/\/www.dbarj.com.br\/wp-content\/uploads\/2019\/09\/RodrigoJorgePOUG19.png"}}]}},"_links":{"self":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/2675","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/comments?post=2675"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/2675\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=2675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=2675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=2675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}