{"id":775,"date":"2020-07-28T14:05:14","date_gmt":"2020-07-28T12:05:14","guid":{"rendered":"http:\/\/rootfan.com\/?p=775"},"modified":"2022-04-04T00:00:21","modified_gmt":"2022-04-03T22:00:21","slug":"crear-tablespace-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/create-tablespace-oracle\/","title":{"rendered":"C\u00f3mo crear un tablespace en Oracle"},"content":{"rendered":"<p>De vez en cuando necesitar\u00e1 crear un nuevo tablespace en su base de datos Oracle.<\/p>\n\n\n\n<p>A continuaci\u00f3n se explica c\u00f3mo crear un tablespace en Oracle.<\/p>\n\n\n\n<p>Espacio de tablas permanente<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE tablespace TS_NAME datafile\nsize 1G AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;\n<\/pre><\/div>\n\n\n<p>Espacio de tablas temporal<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE temporary tablespace TS_TEMP tempfile\nsize 1G AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;\n<\/pre><\/div>\n\n\n<p>Deshacer tablespace<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nCREATE undo tablespace TS_UNDO datafile size 3G;\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">C\u00f3mo aumentar el tama\u00f1o de un tablespace en Oracle<\/h2>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER TABLESPACE TS_NAME ADD DATAFILE \nSIZE 100M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>De vez en cuando necesitar\u00e1s crear un nuevo tablespace en tu base de datos Oracle. A continuaci\u00f3n se explica c\u00f3mo crear un tablespace en Oracle. Espacio de tablas permanente Espacio de tablas temporal Deshacer espacio de tablas C\u00f3mo aumentar el tama\u00f1o de un espacio de tablas en Oracle<\/p>","protected":false},"author":1,"featured_media":2911,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"","rank_math_title":"","rank_math_description":"Step-by-step guide on creating a tablespace in Oracle to organize and manage your database storage efficiently.","rank_math_robots":null,"rank_math_og_title":"","rank_math_og_description":"","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":[31],"tags":[43,42],"class_list":["post-775","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-create","tag-tablespace"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-355747.jpeg?fit=1880%2C1022&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/775","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/comments?post=775"}],"version-history":[{"count":10,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/775\/revisions"}],"predecessor-version":[{"id":2912,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/775\/revisions\/2912"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2911"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}