{"categories":["DB","oracle"],"published":"2008-01-11 19:05:15","type":"rich","provider_url":"https://hatena.blog","width":"100%","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fcynipe.hateblo.jp%2Fentry%2F20080111%2F1200045915\" title=\"\u30c7\u30d5\u30a9\u30eb\u30c8\u4e00\u6642\u8868\u9818\u57df\u306e\u30b5\u30a4\u30ba\u3092\u5c0f\u3055\u304f(\u7e2e\u5c0f)\u3059\u308b - cynipe\u3068\u8aad\u3080\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","url":"https://cynipe.hateblo.jp/entry/20080111/1200045915","title":"\u30c7\u30d5\u30a9\u30eb\u30c8\u4e00\u6642\u8868\u9818\u57df\u306e\u30b5\u30a4\u30ba\u3092\u5c0f\u3055\u304f(\u7e2e\u5c0f)\u3059\u308b","description":"--\u5207\u308a\u66ff\u3048\u7528\u306eDBF\u3092\u4f5c\u308b ALTER TABLESPACE TEMP ADD TEMPFILE 'somehwere/temp02.dbf' SIZE 512M AUTOEXTEND OFF --\u5143\u306e\u5974\u3092OFFLINE\u306b\u3059\u308b ALTER DATABASE TEMPFILE 'somewhere/temp01.dbf' OFFLINE; --DBF\u3054\u3068\u6368\u3066\u308b ALTER DATABASE TEMPFILE 'somewhere/temp01.dbf' DROP INCLUDING DATAFILES; --\u65b0\u3057\u3044\u5974\u3092\u4efb\u610f\u306e\u30b5\u30a4\u30ba\u3067\u4f5c\u308b ALTER TABLESPACE TEMP ADD TE\u2026","image_url":null,"author_name":"cynipe","provider_name":"Hatena Blog","version":"1.0","blog_title":"cynipe\u3068\u8aad\u3080","author_url":"https://blog.hatena.ne.jp/cynipe/","blog_url":"https://cynipe.hateblo.jp/","height":"190"}