{"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":"creer-un-tablespace-oracle","status":"publish","type":"post","link":"https:\/\/rootfan.com\/fr\/create-tablespace-oracle\/","title":{"rendered":"Comment cr\u00e9er un Tablespace dans Oracle"},"content":{"rendered":"<p>De temps \u00e0 autre, vous devrez cr\u00e9er un nouveau tablespace dans votre base de donn\u00e9es Oracle.<\/p>\n\n\n\n<p>Voici comment cr\u00e9er un tablespace dans Oracle.<\/p>\n\n\n\n<p>Espace de stockage permanent<\/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>Espace de stockage temporaire<\/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>Annuler le 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\">Comment augmenter la taille d'un tablespace dans 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 temps \u00e0 autre, vous devrez cr\u00e9er un nouveau tablespace dans votre base de donn\u00e9es Oracle. Voici comment cr\u00e9er un tablespace dans Oracle. Tablespace permanent Tablespace temporaire Tablespace d'annulation Comment augmenter la taille d'un tablespace dans 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\/fr\/wp-json\/wp\/v2\/posts\/775","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=775"}],"version-history":[{"count":10,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/775\/revisions"}],"predecessor-version":[{"id":2912,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/posts\/775\/revisions\/2912"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media\/2911"}],"wp:attachment":[{"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/media?parent=775"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/categories?post=775"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/rootfan.com\/fr\/wp-json\/wp\/v2\/tags?post=775"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}