{"id":1044,"date":"2014-10-30T15:55:37","date_gmt":"2014-10-30T18:55:37","guid":{"rendered":"http:\/\/www.dbarj.com.br\/?p=1044"},"modified":"2014-11-21T11:59:20","modified_gmt":"2014-11-21T14:59:20","slug":"ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces","status":"publish","type":"post","link":"https:\/\/www.dbarj.com.br\/en\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/","title":{"rendered":"OCM 11g Preparation &#8211; Create and manage temporary, permanent, and undo tablespaces"},"content":{"rendered":"<p>Creating tablespaces is one of the most basic thing a DBA must know. If you need to create any in the exam, do not memorialize the syntax. Go to\u00a0the DOC, get an example and adapt as needed. You can also use the DBMS_METADATA to get the DDL of any existent tablespace\u00a0to use as a template.<\/p>\n<p>You must clearly know\u00a0the difference\/advantages\/disadvantages\/consequences\/requirements between:<\/p>\n<ul>\n<li><span style=\"color: #0000ff;\"><strong>BIG \/ SMALL file tablespaces.<\/strong><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><strong>DMT \/ LMT &#8211; Convert between them.<\/strong><\/span><\/li>\n<li><span style=\"color: #0000ff;\"><strong>MSSM \/ ASSM.<\/strong><\/span><\/li>\n<\/ul>\n<p>You must\u00a0also be able to create very fast a new tablespace via sqlplus or EM interface.<\/p>\n<p><strong>Path to Documentation<\/strong>:<\/p>\n<p><span style=\"color: #800000;\">Oracle Database SQL Language Reference -&gt; CREATE TABLESPACE<\/span><br \/>\n<span style=\"color: #800000;\"> Oracle Database Administrator&#8217;s Guide -&gt; Managing Tablespaces<\/span><\/p>\n<br>\r\nClick here to go back to the <a title=\"OCM 11g Preparation\" href=\"\/?page_id=923\">Main OCM 11g 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-1044 jlk' href='javascript:void(0)' data-task='like' data-post_id='1044' 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-1044 lc'>+6<\/span><\/a><\/div><\/div> <div class='status-1044 status align-left'><\/div><\/div><div class='wti-clear'><\/div>","protected":false},"excerpt":{"rendered":"<p>Creating tablespaces is one of the most basic thing a DBA must know. If you need to create any in the exam, do not memorialize the syntax. Go to\u00a0the DOC, get an example and adapt as needed. You can also use the DBMS_METADATA to get the DDL of any existent tablespace\u00a0to use as a template. &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"https:\/\/www.dbarj.com.br\/en\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/\">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":[27],"tags":[],"class_list":["post-1044","post","type-post","status-publish","format-standard","hentry","category-ocm11g-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 11g Preparation - Create and manage temporary, permanent, and undo tablespaces - DBA - Rodrigo Jorge - Oracle Tips and Guides<\/title>\n<meta name=\"description\" content=\"Create and manage temporary, permanent, and undo tablespaces for Oracle OCM 11g 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\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/\" \/>\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\\\/2014\\\/10\\\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2014\\\/10\\\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\\\/\"},\"author\":{\"name\":\"DBA RJ\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"headline\":\"OCM 11g Preparation &#8211; Create and manage temporary, permanent, and undo tablespaces\",\"datePublished\":\"2014-10-30T18:55:37+00:00\",\"dateModified\":\"2014-11-21T14:59:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2014\\\/10\\\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\\\/\"},\"wordCount\":135,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#\\\/schema\\\/person\\\/28a44ca3a6633fe4156ad1ea209d40a9\"},\"articleSection\":[\"OCM 11g Preparation\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2014\\\/10\\\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2014\\\/10\\\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\\\/\",\"url\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2014\\\/10\\\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\\\/\",\"name\":\"OCM 11g Preparation - Create and manage temporary, permanent, and undo tablespaces - DBA - Rodrigo Jorge - Oracle Tips and Guides\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/#website\"},\"datePublished\":\"2014-10-30T18:55:37+00:00\",\"dateModified\":\"2014-11-21T14:59:20+00:00\",\"description\":\"Create and manage temporary, permanent, and undo tablespaces for Oracle OCM 11g Certification\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2014\\\/10\\\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2014\\\/10\\\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/2014\\\/10\\\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbarj.com.br\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"OCM 11g Preparation - Create and manage temporary, permanent, and undo tablespaces\"}]},{\"@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 11g Preparation - Create and manage temporary, permanent, and undo tablespaces - DBA - Rodrigo Jorge - Oracle Tips and Guides","description":"Create and manage temporary, permanent, and undo tablespaces for Oracle OCM 11g 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\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/","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\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/#article","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/"},"author":{"name":"DBA RJ","@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"headline":"OCM 11g Preparation &#8211; Create and manage temporary, permanent, and undo tablespaces","datePublished":"2014-10-30T18:55:37+00:00","dateModified":"2014-11-21T14:59:20+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbarj.com.br\/en\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/"},"wordCount":135,"commentCount":3,"publisher":{"@id":"https:\/\/www.dbarj.com.br\/en\/#\/schema\/person\/28a44ca3a6633fe4156ad1ea209d40a9"},"articleSection":["OCM 11g Preparation"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbarj.com.br\/en\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbarj.com.br\/en\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/","url":"https:\/\/www.dbarj.com.br\/en\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/","name":"OCM 11g Preparation - Create and manage temporary, permanent, and undo tablespaces - DBA - Rodrigo Jorge - Oracle Tips and Guides","isPartOf":{"@id":"https:\/\/www.dbarj.com.br\/en\/#website"},"datePublished":"2014-10-30T18:55:37+00:00","dateModified":"2014-11-21T14:59:20+00:00","description":"Create and manage temporary, permanent, and undo tablespaces for Oracle OCM 11g Certification","breadcrumb":{"@id":"https:\/\/www.dbarj.com.br\/en\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbarj.com.br\/en\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbarj.com.br\/en\/2014\/10\/ocm-11g-preparation-create-manage-temporary-permanent-undo-tablespaces\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbarj.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"OCM 11g Preparation - Create and manage temporary, permanent, and undo tablespaces"}]},{"@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\/1044","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=1044"}],"version-history":[{"count":0,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/posts\/1044\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/media?parent=1044"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/categories?post=1044"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbarj.com.br\/en\/wp-json\/wp\/v2\/tags?post=1044"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}