{"id":241,"date":"2019-04-30T16:59:08","date_gmt":"2019-04-30T15:59:08","guid":{"rendered":"http:\/\/www.infonix.eu\/?p=241"},"modified":"2026-01-14T22:00:28","modified_gmt":"2026-01-14T21:00:28","slug":"oracle-rac-augmenter-un-tablespace","status":"publish","type":"post","link":"https:\/\/www.infonix.eu\/?p=241","title":{"rendered":"Oracle RAC – Augmenter un tablespace"},"content":{"rendered":"

Lorsque la taille des tablespaces d\u00e9passent les 90% il est temps d’augmenter leurs tailles. Voici comment proc\u00e9der :
\n
\n1 – Se connecter \u00e0 l’application TOAD
\n2- Ouvrir la base de donn\u00e9es de votre choix via la connexion TNS
\n3 – Aller dans l’onglet \u00ab\u00a0DATABASE\u00a0\u00bb puis ‘Administrer\u00a0\u00bb et enfin \u00ab\u00a0Tablespaces\u00a0\u00bb
\n4 – Double cliquer sur le tablespace en limite d’espace, vous pouvez voir le taux occupation dans la colonne \u00ab\u00a0Used Pct of Max\u00a0\u00bb
\n5 – Double cliquer sur le \u00ab\u00a0Data Files\u00a0\u00bb
\n6 – Lorsqu’un fichier est en \u00ab\u00a0autoextend\u00a0\u00bb le d\u00e9cocher puis cliquer sur \u00ab\u00a0Add\u00a0\u00bb afin d’en ajouter un nouveau
\n7 – Dans la nouvelle fen\u00eatre, cliquer sur \u00ab\u00a0Add Oracle Managed File\u00a0\u00bb afin de nommer automatiquement le fichier puis d\u00e9finir la taille du fichier \u00e0 \u00ab\u00a0100MB\u00a0\u00bb par exemple. Cocher l’autoextend d\u00e9finit sur 100 MB ou 200 MB et le \u00ab\u00a0Maximum size\u00a0\u00bb \u00e0 la m\u00eame taille que les anciens fichiers.
\n8 – Valider puis quitter l’application<\/p>\n","protected":false},"excerpt":{"rendered":"

Lorsque la taille des tablespaces d\u00e9passent les 90% il est temps d’augmenter leurs tailles. Voici comment proc\u00e9der :<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-241","post","type-post","status-publish","format-standard","hentry","category-non-classe"],"_links":{"self":[{"href":"https:\/\/www.infonix.eu\/index.php?rest_route=\/wp\/v2\/posts\/241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.infonix.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.infonix.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.infonix.eu\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.infonix.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=241"}],"version-history":[{"count":1,"href":"https:\/\/www.infonix.eu\/index.php?rest_route=\/wp\/v2\/posts\/241\/revisions"}],"predecessor-version":[{"id":399,"href":"https:\/\/www.infonix.eu\/index.php?rest_route=\/wp\/v2\/posts\/241\/revisions\/399"}],"wp:attachment":[{"href":"https:\/\/www.infonix.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.infonix.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.infonix.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}