{"id":1417,"date":"2021-01-16T12:26:46","date_gmt":"2021-01-16T11:26:46","guid":{"rendered":"http:\/\/rootfan.com\/?p=1417"},"modified":"2022-04-04T00:16:26","modified_gmt":"2022-04-03T22:16:26","slug":"borrar-archivo-de-datos-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/es\/delete-datafile-oracle\/","title":{"rendered":"C\u00f3mo eliminar un archivo de datos en Oracle"},"content":{"rendered":"<p>Debe utilizar el <code>DROP<\/code> <code>ARCHIVO DE DATOS<\/code> y <code>DROP<\/code> <code>TEMPFILE<\/code> cl\u00e1usulas del <code>ALTERAR<\/code> <code>TABLESPACE<\/code> para eliminar un \u00fanico archivo de datos o temporal.<\/p>\n\n\n\n<p>He aqu\u00ed algunos ejemplos.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER TABLESPACE example1 \nDROP DATAFILE &#039;+DGROUP1\/example1.dbf&#039;;\n<\/pre><\/div>\n\n\n<p>Este otro ejemplo deja caer un archivo temporal.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code\" data-no-translation=\"\"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nALTER TABLESPACE temp \nDROP TEMPFILE &#039;\/u02\/oracle\/data\/temp03.dbf&#039;;\n<\/pre><\/div>\n\n\n<p>La base de datos debe estar abierta y el archivo de datos vac\u00edo.<\/p>\n\n\n\n<p>No se pueden eliminar archivos de datos en tablespaces de s\u00f3lo lectura ni en el tablespace SYSTEM.<\/p>","protected":false},"excerpt":{"rendered":"<p>Debes utilizar las cl\u00e1usulas DROP DATAFILE y DROP TEMPFILE del comando ALTER TABLESPACE para eliminar un \u00fanico archivo de datos o tempfile. Aqu\u00ed tienes algunos ejemplos. Este otro ejemplo elimina un archivo temporal. La base de datos debe estar abierta y el fichero de datos debe estar vac\u00edo. No se pueden eliminar archivos de datos en tablespaces de s\u00f3lo lectura ni en el tablespace SYSTEM.<\/p>","protected":false},"author":1,"featured_media":2926,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_focus_keyword":"how to delete a datafile in oracle","rank_math_title":"","rank_math_description":"Delete a datafile in Oracle effortlessly. Follow this step-by-step guide to successfully delete a datafile in Oracle.","rank_math_robots":"","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":[69,68],"class_list":["post-1417","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-oracle","tag-datafile","tag-drop"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/rootfan.com\/wp-content\/uploads\/pexels-photo-131723.jpeg?fit=1880%2C1249&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1417","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=1417"}],"version-history":[{"count":6,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1417\/revisions"}],"predecessor-version":[{"id":1627,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/posts\/1417\/revisions\/1627"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media\/2926"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/media?parent=1417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/categories?post=1417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/es\/wp-json\/wp\/v2\/tags?post=1417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}