{"id":67,"date":"2011-09-02T23:53:59","date_gmt":"2011-09-02T15:53:59","guid":{"rendered":"https:\/\/yangtingkun.net\/?p=67"},"modified":"2011-09-19T22:02:48","modified_gmt":"2011-09-19T14:02:48","slug":"%e4%b8%b4%e6%97%b6%e8%a1%a8%e7%9a%84%e8%a1%a8%e7%a9%ba%e9%97%b4","status":"publish","type":"post","link":"https:\/\/yangtingkun.net\/?p=67","title":{"rendered":"\u4e34\u65f6\u8868\u7684\u8868\u7a7a\u95f4"},"content":{"rendered":"<p>\u7b80\u5355\u63cf\u8ff0\u4e34\u65f6\u8868\u7684\u5b58\u50a8\u7279\u70b9\u3002<br \/>\n\u4e34\u65f6\u8868\u7684\u6570\u636e\u5b58\u50a8\u5728\u4e34\u65f6\u8868\u7a7a\u95f4\u4e2d\uff0c\u8fd9\u4e00\u70b9\u5f88\u663e\u7136\uff0c\u4e0d\u8fc7\u4e3a\u4ec0\u4e48\u4e34\u65f6\u8868\u5728DBA_TABLES\u89c6\u56fe\u4e2d\u663e\u793a\u7684\u8868\u7a7a\u95f4\u4e3a\u7a7a\uff0c\u4ee5\u524d\u786e\u5b9e\u4e00\u76f4\u4e0d\u662f\u5f88\u6e05\u695a\u3002<br \/>\n\u524d\u4e24\u5929\u5728\u548cKAMUS\u8ba8\u8bba\u4e34\u65f6\u8868\u7684\u5b9e\u73b0\u65f6\uff0c\u7a81\u7136\u610f\u8bc6\u5230\u8fd9\u4e00\u70b9\uff0c\u7531\u4e8e\u4e34\u65f6\u8868\u53ef\u4ee5\u88ab\u591a\u4e2a\u7528\u6237\u8bbf\u95ee\uff0c\u800c\u4e0d\u540c\u7528\u6237\u7684\u9ed8\u8ba4\u4e34\u65f6\u8868\u7a7a\u95f4\u7684\u8bbe\u7f6e\u53ef\u80fd\u4e0d\u540c\uff0c\u8fd9\u5c31\u610f\u5473\u7740\u4e34\u65f6\u8868\u7684\u591a\u4e2a\u4e34\u65f6\u6bb5\u53ef\u80fd\u5b58\u50a8\u5728\u591a\u4e2a\u4e34\u65f6\u8868\u7a7a\u95f4\u4e2d\uff0c\u6b63\u662f\u8fd9\u4e2a\u539f\u56e0\uff0c\u5bfc\u81f4\u4e86\u4e34\u65f6\u8868\u5bf9\u5e94\u7684\u8868\u7a7a\u95f4\u4fe1\u606f\u4e3a\u7a7a\u3002<br \/>\n\u4e0b\u9762\u8fd9\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\u8bf4\u660e\u4e86\u8fd9\u79cd\u60c5\u51b5\uff1a<\/p>\n<pre lang='SQL'>SQL> CONN \/ AS SYSDBA\r\n\u5df2\u8fde\u63a5\u3002\r\nSQL> SET PAGES 100 LINES 120\r\nSQL> COL FILE_NAME FORMAT A50\r\nSQL> SELECT TABLESPACE_NAME, FILE_NAME FROM DBA_TEMP_FILES;\r\nTABLESPACE_NAME                FILE_NAME\r\n------------------------------ ---------------------------------------------\r\nTEMP                           D:\\ORACLE\\ORADATA\\YTK102\\TEMP01.DBF\r\nSQL> SELECT USERNAME, TEMPORARY_TABLESPACE FROM DBA_USERS WHERE USERNAME = 'TEST';\r\nUSERNAME                       TEMPORARY_TABLESPACE\r\n------------------------------ ------------------------------\r\nTEST                           TEMP\r\nSQL> CREATE TEMPORARY TABLESPACE TEMP2 TEMPFILE 'D:\\ORACLE\\ORADATA\\YTK102\\TEMP201.DBF' SIZE 100M;\r\n\u8868\u7a7a\u95f4\u5df2\u521b\u5efa\u3002\r\nSQL> CREATE USER TEST2 IDENTIFIED BY TEST2 TEMPORARY TABLESPACE TEMP2;\r\n\u7528\u6237\u5df2\u521b\u5efa\u3002\r\nSQL> GRANT CREATE SESSION TO TEST2;\r\n\u6388\u6743\u6210\u529f\u3002\r\nSQL> CONN TEST\/TEST\r\n\u5df2\u8fde\u63a5\u3002\r\nSQL> CREATE GLOBAL TEMPORARY TABLE TMP1 (ID NUMBER);\r\n\u8868\u5df2\u521b\u5efa\u3002\r\nSQL> GRANT ALL ON TMP1 TO TEST2;\r\n\u6388\u6743\u6210\u529f\u3002\r\nSQL> CONN TEST2\/TEST2\r\n\u5df2\u8fde\u63a5\u3002\r\nSQL> INSERT INTO TEST.TMP1 VALUES (1);\r\n\u5df2\u521b\u5efa 1 \u884c\u3002\r\nSQL> CONN TEST\/TEST\r\n\u5df2\u8fde\u63a5\u3002\r\nSQL> INSERT INTO TMP1 VALUES (2);\r\n\u5df2\u521b\u5efa 1 \u884c\u3002\r\nSQL> ALTER TABLESPACE TEMP2 TEMPFILE OFFLINE;\r\n\u8868\u7a7a\u95f4\u5df2\u66f4\u6539\u3002\r\nSQL> CONN TEST\/TEST\r\n\u5df2\u8fde\u63a5\u3002\r\nSQL> INSERT INTO TMP1 VALUES (3);\r\n\u5df2\u521b\u5efa 1 \u884c\u3002\r\nSQL> CONN TEST2\/TEST2\r\n\u5df2\u8fde\u63a5\u3002\r\nSQL> INSERT INTO TEST.TMP1 VALUES (4);\r\nINSERT INTO TEST.TMP1 VALUES (4)\r\n                 *\r\n\u7b2c 1 \u884c\u51fa\u73b0\u9519\u8bef:\r\nORA-01652: \u65e0\u6cd5\u901a\u8fc7 128 (\u5728\u8868\u7a7a\u95f4 TEMP2 \u4e2d) \u6269\u5c55 temp \u6bb5<\/pre>\n<p>\u5404\u4e2a\u4f1a\u8bdd\u5728\u8bbf\u95ee\u4e34\u65f6\u8868\u7684\u65f6\u5019\uff0c\u90fd\u4f1a\u62e5\u6709\u81ea\u5df1\u72ec\u7acb\u7684\u4e34\u65f6\u8868\u6bb5\uff0c\u800c\u5f53\u591a\u4e2a\u7528\u6237\u7684\u9ed8\u8ba4\u4e34\u65f6\u8868\u7a7a\u95f4\u4e0d\u540c\u65f6\uff0c\u4e34\u65f6\u8868\u5c31\u53ef\u80fd\u5728\u591a\u4e2a\u4e34\u65f6\u8868\u7a7a\u95f4\u4e0a\u5efa\u7acb\u4e34\u65f6\u6bb5\uff0c\u6b63\u662f\u8fd9\u4e2a\u539f\u56e0\u4f7f\u5f97\u4e34\u65f6\u6bb5\u7684\u8868\u7a7a\u95f4\u5c5e\u6027\u65e0\u6cd5\u786e\u5b9a\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u7b80\u5355\u63cf\u8ff0\u4e34\u65f6\u8868\u7684\u5b58\u50a8\u7279\u70b9\u3002 \u4e34\u65f6\u8868\u7684\u6570\u636e\u5b58\u50a8\u5728\u4e34\u65f6\u8868\u7a7a\u95f4\u4e2d\uff0c\u8fd9\u4e00\u70b9\u5f88\u663e\u7136\uff0c\u4e0d\u8fc7\u4e3a\u4ec0\u4e48\u4e34\u65f6\u8868\u5728DBA_TABLES\u89c6\u56fe\u4e2d\u663e\u793a\u7684\u8868\u7a7a\u95f4\u4e3a\u7a7a\uff0c\u4ee5\u524d\u786e\u5b9e\u4e00\u76f4\u4e0d\u662f\u5f88\u6e05\u695a\u3002 \u524d\u4e24\u5929\u5728\u548cKAMUS\u8ba8\u8bba\u4e34\u65f6\u8868\u7684\u5b9e\u73b0\u65f6\uff0c\u7a81\u7136\u610f\u8bc6\u5230\u8fd9\u4e00\u70b9\uff0c\u7531\u4e8e\u4e34\u65f6\u8868\u53ef\u4ee5\u88ab\u591a\u4e2a\u7528\u6237\u8bbf\u95ee\uff0c\u800c\u4e0d\u540c\u7528\u6237\u7684\u9ed8\u8ba4\u4e34\u65f6\u8868\u7a7a\u95f4\u7684\u8bbe\u7f6e\u53ef\u80fd\u4e0d\u540c\uff0c\u8fd9\u5c31\u610f\u5473\u7740\u4e34\u65f6\u8868\u7684\u591a\u4e2a\u4e34\u65f6\u6bb5\u53ef\u80fd\u5b58\u50a8\u5728\u591a\u4e2a\u4e34\u65f6\u8868\u7a7a\u95f4\u4e2d\uff0c\u6b63\u662f\u8fd9\u4e2a\u539f\u56e0\uff0c\u5bfc\u81f4\u4e86\u4e34\u65f6\u8868\u5bf9\u5e94\u7684\u8868\u7a7a\u95f4\u4fe1\u606f\u4e3a\u7a7a\u3002 \u4e0b\u9762\u8fd9\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\u8bf4\u660e\u4e86\u8fd9\u79cd\u60c5\u51b5\uff1a SQL> CONN \/ AS SYSDBA \u5df2\u8fde\u63a5\u3002 SQL> SET PAGES 100 LINES 120 SQL> COL FILE_NAME FORMAT A50 SQL> SELECT TABLESPACE_NAME, FILE_NAME FROM DBA_TEMP_FILES; TABLESPACE_NAME FILE_NAME &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; TEMP D:\\ORACLE\\ORADATA\\YTK102\\TEMP01.DBF SQL> SELECT USERNAME, TEMPORARY_TABLESPACE FROM DBA_USERS WHERE &hellip; <a href=\"https:\/\/yangtingkun.net\/?p=67\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_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":[3],"tags":[12],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2yiY3-15","_links":{"self":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/67"}],"collection":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=67"}],"version-history":[{"count":2,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions"}],"predecessor-version":[{"id":111,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions\/111"}],"wp:attachment":[{"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yangtingkun.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}