{"author_url":"https://blog.hatena.ne.jp/yohei-a/","blog_title":"ablog","version":"1.0","width":"100%","published":"2010-03-29 16:20:02","blog_url":"https://yohei-a.hatenablog.jp/","image_url":null,"categories":["Oracle"],"url":"https://yohei-a.hatenablog.jp/entry/20100329/1269847202","provider_url":"https://hatena.blog","description":"Oracle \u306b\u63a5\u7d9a\u3059\u308b\u3002 $ sqlplus / as sysdba \u65b0\u3057\u3044UNDO\u8868\u9818\u57df\u3092\u4e00\u6642\u7684\u306b\u4f5c\u6210\u3059\u308b\u3002 SQL> CREATE UNDO TABLESPACE UNDOTBS2 DATAFILE '/u02/oradata/orcl/undotbs02_01.dbf' SIZE 4G; \u65b0\u3057\u304f\u4f5c\u3063\u305fUNDO\u9818\u57df\u306b\u5207\u308a\u66ff\u3048\u308b\u3002 SQL> ALTER SYSTEM SET UNDO_TABLESPACE = 'UNDOTBS2'; \u5143\u306eUNDO\u8868\u9818\u57df\u3092\u524a\u9664\u3059\u308b\u3002 SQL> ALTER TABLESPACE UNDOTBS1 OFFLINE NORMAL; SQL> shutdown im\u2026","provider_name":"Hatena Blog","author_name":"yohei-a","title":"UNDO\u8868\u9818\u57df\u3092\u518d\u4f5c\u6210\u3057\u3066\u30af\u30ea\u30a2\u3057\u305f\u624b\u9806","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fyohei-a.hatenablog.jp%2Fentry%2F20100329%2F1269847202\" title=\"UNDO\u8868\u9818\u57df\u3092\u518d\u4f5c\u6210\u3057\u3066\u30af\u30ea\u30a2\u3057\u305f\u624b\u9806 - ablog\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","height":"190"}