{"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":"supprimer-le-fichier-de-donnees-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/delete-datafile-oracle\/","title":{"rendered":"Comment supprimer un fichier de donn\u00e9es dans Oracle"},"content":{"rendered":"<p>Vous devez utiliser le <code>DROP<\/code> <code>DATAFILE<\/code> et <code>DROP<\/code> <code>TEMPFILE<\/code> des clauses de la <code>ALTER<\/code> <code>TABLESPACE<\/code> pour supprimer un seul fichier de donn\u00e9es ou un fichier temporaire.<\/p>\n\n\n\n<p>Voici quelques exemples.<\/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>Cet autre exemple supprime un fichier temporaire.<\/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 donn\u00e9es doit \u00eatre ouverte et le fichier de donn\u00e9es doit \u00eatre vide.<\/p>\n\n\n\n<p>Vous ne pouvez pas d\u00e9poser de fichiers de donn\u00e9es dans les tablespaces en lecture seule et dans le tablespace SYSTEM.<\/p>","protected":false},"excerpt":{"rendered":"<p>Vous devez utiliser les clauses DROP DATAFILE et DROP TEMPFILE de la commande ALTER TABLESPACE pour supprimer un seul fichier de donn\u00e9es ou fichier temporaire. Voici quelques exemples. Cet autre exemple supprime un fichier temporaire. La base de donn\u00e9es doit \u00eatre ouverte et le fichier de donn\u00e9es doit \u00eatre vide. Vous ne pouvez pas supprimer des fichiers de donn\u00e9es dans les tablespaces en lecture seule et dans le 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\/fr\/wp-json\/wp\/v2\/posts\/1417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/comments?post=1417"}],"version-history":[{"count":6,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1417\/revisions"}],"predecessor-version":[{"id":1627,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/1417\/revisions\/1627"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2926"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=1417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=1417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=1417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}