{"rsdb":{"rid":"301973","subhead":"","postdate":"0","aid":"217201","fid":"57","uid":"1","topic":"1","content":"<p>&nbsp; \u4ee5SYSDBA\u8eab\u4efd\u767b\u5f55<\/p><br\/><p style=\"white-space: normal;\">&nbsp; \u6570\u636e\u5e93\u5173\u95ed\u547d\u4ee4\uff1a<span style=\"color: #ff0000;\">SHUTDOWN \u3010\u542f\u52a8\u9009\u9879\u3011<\/span><\/p><br\/><p style=\"white-space: normal;\">&nbsp; \u6570\u636e\u5e93\u5173\u95ed\u4e09\u4e2a\u9636\u6bb5\uff1a<\/p><br\/><p style=\"white-space: normal;\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \u5173\u95ed\u6570\u636e\u5e93<\/p><br\/><p style=\"white-space: normal;\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \u5378\u8f7d\u6570\u636e\u5e93<\/p><br\/><p style=\"white-space: normal;\">&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; \u5173\u95edOravle\u5b9e\u4f8b<\/p><br\/><p style=\"white-space: normal;\"><img src=\"..\/..\/upload\/2019_04\/190403222213994.png\" alt=\"\" \/><\/p><br\/><p style=\"white-space: normal;\"><img src=\"..\/..\/upload\/2019_04\/190403222213995.png\" alt=\"\" \/><\/p><br\/><p style=\"white-space: normal;\"><span style=\"font-size: 24px;\">\u4e8c\u3001\u542f\u52a8\u3001\u5173\u95edOracle\u76d1\u542c\u8fdb\u7a0b<\/span><\/p><br\/><p><span style=\"font-size: 16px;\"><img src=\"..\/..\/upload\/2019_04\/190403222213991.gif\" alt=\"\" \/><span style=\"font-family: \u9ed1\u4f53; vertical-align: baseline;\">\u76d1\u542c\u5668<\/span><span style=\"font-family: Arial; vertical-align: baseline;\">lsnrctl<\/span><span style=\"font-family: \u9ed1\u4f53; vertical-align: baseline;\">\uff1a\u63d0\u4f9b\u6570\u636e\u5e93\u8bbf\u95ee\uff0c\u9ed8\u8ba4\u7aef\u53e3<\/span><span style=\"font-family: Arial; vertical-align: baseline; color: red;\">1521<\/span><\/span><\/p><br\/><p><span style=\"font-size: 16px;\"><img src=\"..\/..\/upload\/2019_04\/190403222213991.gif\" alt=\"\" \/><span style=\"font-family: \u9ed1\u4f53; vertical-align: baseline;\">\u4e3a\u4e86\u4f7f\u5ba2\u6237\u7aef\u7528\u6237\u80fd\u8fde\u63a5\u5230<\/span><span style=\"font-family: Arial; vertical-align: baseline;\">Oracle<\/span><span style=\"font-family: \u9ed1\u4f53; vertical-align: baseline;\">\u5b9e\u4f8b\uff0c\u8981\u542f\u52a8\u76d1\u542c<\/span><\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: \u9ed1\u4f53; vertical-align: baseline;\">1.\u542f\u52a8\u76d1\u542c<\/span><\/p><br\/><p><span style=\"font-family: \u9ed1\u4f53;\">\u542f\u52a8\uff08START\uff09\u76d1\u542c\u662fOracle\u7528\u6237\u5728\u64cd\u4f5c\u7cfb\u7edf\u4e0b\u6267\u884c\u7684\u547d\u4ee4\uff0c\u53ef\u4ee5\u76f4\u63a5\u5728LSNRCTL\u540e\u52a0\u53c2\u6570\uff0c\u4e5f\u53ef\u4ee5\u5728\u8be5\u547d\u4ee4\u63d0\u793a\u7b26\u540e\u5728\u8fdb\u884c\u64cd\u4f5c\u3002<\/span><\/p><br\/><p><span style=\"font-family: \u9ed1\u4f53;\"><img src=\"..\/..\/upload\/2019_04\/190403222213996.png\" alt=\"\" \/><\/span><\/p><br\/><p><span style=\"font-family: \u9ed1\u4f53;\">2.\u5173\u95ed\u76d1\u542c<\/span><\/p><br\/><p><span style=\"font-family: \u9ed1\u4f53;\"><img src=\"..\/..\/upload\/2019_04\/190403222213997.png\" alt=\"\" \/><\/span><\/p><br\/><p><span style=\"font-family: \u9ed1\u4f53; color: #ff0000;\">\u6ce8\u610f\uff1a\u5148\u542f\u52a8\u76d1\u542c\uff0c\u540e\u542f\u52a8\u6570\u636e\u5e93\u3002<\/span><\/p><br\/><p style=\"white-space: normal;\">&nbsp;<\/p><br\/><p style=\"white-space: normal;\"><span style=\"font-size: 24px;\">\u4e09\u3001\u8868\u7a7a\u95f4<\/span><\/p><br\/><p style=\"white-space: normal;\">\uff081\uff09\u8c03\u6574\u8868\u7a7a\u95f4\u7684\u5927\u5c0f\u3002\u5f53\u8868\u7a7a\u95f4\u5df2\u6ee1\u7684\u60c5\u51b5\u4e0b\uff0c\u53ef\u4ee5\u901a\u8fc7ALTER\u8bed\u53e5\u6765\u8c03\u6574\u8868\u7a7a\u95f4\u7684\u5927\u5c0f\u3002<\/p><br\/><p style=\"white-space: normal;\">&nbsp; \u65b9\u6cd5\u4e00\uff1a\u66f4\u6539\u6570\u636e\u6587\u4ef6\u7684\u5927\u5c0f\uff0c\u5e76\u6307\u660e\u6570\u636e\u6587\u4ef6\u7684\u5b58\u653e\u8def\u5f84\uff0c\u901a\u8fc7\u4f7f\u7528RESIZE\u5173\u952e\u5b57\uff0c\u7528\u4e8e\u6307\u5b9a\u8c03\u6574\u540e\u7684\u8868\u7a7a\u95f4\u7684\u5927\u5c0f<\/p><br\/><p style=\"white-space: normal;\">&nbsp; <img src=\"..\/..\/upload\/2019_04\/1904032222139910.png\" alt=\"\" \/><\/p><br\/><p style=\"white-space: normal;\">&nbsp; \u65b9\u6cd5\u4e8c\uff1a\u5411\u8868\u7a7a\u95f4\u5185\u6dfb\u52a0\u6570\u636e\u6587\u4ef6\u3002\u4e3a\u8868\u7a7a\u95f4\u6dfb\u52a0\u4e00\u4e2a\u65b0\u7684\u6570\u636e\u6587\u4ef6<\/p><br\/><p style=\"white-space: normal;\">&nbsp; <img src=\"..\/..\/upload\/2019_04\/1904032222139911.png\" alt=\"\" \/><\/p><br\/><p style=\"white-space: normal;\">&nbsp;\uff082\uff09\u6539\u53d8\u8868\u7a7a\u95f4\u7684\u8bfb\u5199\u72b6\u6001\u3002<\/p><br\/><p style=\"white-space: normal;\">&nbsp;<span style=\"color: #ff0000;\">ALTER &nbsp;TABLESPACE &nbsp;\u8868\u7a7a\u95f4\u540d &nbsp;READ &nbsp; WHITE ;<\/span> &nbsp; &nbsp; &nbsp;--\u4f7f\u8868\u7a7a\u95f4\u53ef\u8bfb\u5199<\/p><br\/><p style=\"white-space: normal;\">&nbsp;<span style=\"color: #ff0000;\">ALTER &nbsp;TABLESPACE &nbsp;\u8868\u7a7a\u95f4\u540d &nbsp;READ &nbsp; ONLY ;<\/span> &nbsp; &nbsp; &nbsp; --\u4f7f\u8868\u7a7a\u95f4\u53ea\u8bfb<\/p><br\/><p style=\"white-space: normal;\">&nbsp;\uff083\uff09\u5220\u9664\u8868\u7a7a\u95f4\uff0c\u53ef\u4ee5\u901a\u8fc7DROP\u8bed\u53e5\u6765\u5220\u9664\u8868\u7a7a\u95f4\uff0c\u518d\u52a0\u4e0a\u8868\u7a7a\u95f4\u7684\u540d\u5b57\u5373\u53ef\u3002<\/p><br\/><p style=\"white-space: normal;\">&nbsp;<span style=\"color: #ff0000;\">DROP &nbsp;TABLESPACE &nbsp;\u8868\u7a7a\u95f4\u540d [INCLUDING &nbsp;CONTENTS] ;<\/span><\/p><br\/><p style=\"white-space: normal;\">\u5176\u4e2dINCLUDING &nbsp;CONTENTS\u662f\u53ef\u9009\u9879\u3002\u5982\u679c\u5220\u9664\u4ecd\u5305\u542b\u6570\u636e\u7684\u8868\u7a7a\u95f4\uff0c\u9700\u8981\u52a0\u4e0a\u8be5\u9009\u9879\u3002<\/p><br\/><p style=\"white-space: normal;\"><span style=\"font-size: 24px;\">\u56db\u3001\u7528\u6237\u7ba1\u7406<\/span><\/p><br\/><p style=\"white-space: normal;\">\u521b\u5efa\u7528\u6237\u524d\u7684\u51c6\u5907\u5de5\u4f5c\uff1a<\/p><br\/><p style=\"margin-left: 28px;\">1)<span style=\"font-size: 9px; font-family: 'Times New Roman'; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; &nbsp; &nbsp; <\/span><span style=\"font-family: \u5b8b\u4f53;\">\u9009\u62e9\u7528\u6237\u540d\u548c\u5bc6\u7801<\/span><\/p><br\/><p style=\"margin-left: 28px;\">2)<span style=\"font-size: 9px; font-family: 'Times New Roman'; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; &nbsp; &nbsp; <\/span><span style=\"font-family: \u5b8b\u4f53;\">\u8bc6\u522b\u7528\u6237\u9700\u7528\u4e8e\u5b58\u50a8\u5bf9\u8c61\u7684\u8868\u7a7a\u95f4<\/span><\/p><br\/><p style=\"margin-left: 28px;\">3)<span style=\"font-size: 9px; font-family: 'Times New Roman'; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; &nbsp; &nbsp; <\/span><span style=\"font-family: \u5b8b\u4f53;\">\u51b3\u5b9a\u6bcf\u4e2a\u8868\u7a7a\u95f4\u7684\u9650\u989d<\/span><\/p><br\/><p style=\"margin-left: 28px;\">4)<span style=\"font-size: 9px; font-family: 'Times New Roman'; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; &nbsp; &nbsp; <\/span><span style=\"font-family: \u5b8b\u4f53;\">\u5206\u914d\u7f3a\u7701\u8868\u7a7a\u95f4\u548c\u4e34\u65f6\u8868\u7a7a\u95f4<\/span><\/p><br\/><p style=\"margin-left: 28px;\">5)<span style=\"font-size: 9px; font-family: 'Times New Roman'; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; &nbsp; &nbsp; <\/span><span style=\"font-family: \u5b8b\u4f53;\">\u521b\u5efa\u7528\u6237<\/span><\/p><br\/><p style=\"margin-left: 28px;\">6)<span style=\"font-size: 9px; font-family: 'Times New Roman'; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; &nbsp; &nbsp; <\/span><span style=\"font-family: \u5b8b\u4f53;\">\u5411\u7528\u6237\u6388\u4e88\u6743\u9650\u548c\u89d2\u8272<\/span><\/p><br\/><p style=\"white-space: normal;\"><span style=\"font-size: 24px;\">\u4e94\u3001\u6570\u636e\u5e93\u6743\u9650\u7ba1\u7406<\/span><\/p><br\/><p><span style=\"font-size: 24px;\">&nbsp;\u516d\u3001\u4e8b\u52a1\u63a7\u5236<\/span><\/p><br\/><p><img src=\"..\/..\/upload\/2019_04\/1904032222139918.png\" alt=\"\" \/><\/p><br\/><p>&nbsp;COMMIT\uff1a\u63d0\u4ea4\u4e8b\u52a1\uff0c\u5373\u628a\u4e8b\u52a1\u4e2d\u5bf9\u6570\u636e\u5e93\u7684\u4fee\u6539\u8fdb\u884c\u6c38\u4e45\u4fdd\u5b58\u3002<\/p><br\/><p>&nbsp;ROLLBACK\uff1a\u56de\u6eda\u4e8b\u52a1\uff0c\u5373\u53d6\u6d88\u5bf9\u6570\u636e\u5e93\u6240\u505a\u7684\u4efb\u4f55\u4fee\u6539<\/p><br\/><p>&nbsp;\u81ea\u52a8\u63d0\u4ea4\uff1a &nbsp;set &nbsp;autocommit on<\/p><br\/><p>&nbsp;\u5173\u95ed\u81ea\u52a8\u63d0\u4ea4\uff1a set autocommit off<\/p><br\/><p><span style=\"font-size: 24px;\">&nbsp;\u4e03\u3001\u7d22\u5f15<\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">\u7d22\u5f15\u662foracle\u7684\u4e00\u4e2a\u5bf9\u8c61\uff0c\u662f\u4e0e\u8868\u5173\u8054\u7684\u53ef\u9009\u7ed3\u6784\uff0c\u63d0\u4f9b\u4e86\u4e00\u79cd\u5feb\u901f\u8bbf\u95ee\u6570\u636e\u7684\u9014\u5f84\uff0c\u63d0\u9ad8\u4e86\u6570\u636e\u5e93\u68c0\u7d22\u6027\u80fd\u3002\u7d22\u5f15\u4f7f\u6570\u636e\u5e93\u7a0b\u5e8f\u65e0\u9700\u5bf9\u6574\u4e2a\u8868\u8fdb\u884c\u626b\u63cf\uff0c\u5c31\u53ef\u4ee5\u5728\u5176\u4e2d\u627e\u5230\u6240\u9700\u8981\u7684\u6570\u636e\u3002\u5c31\u50cf\u4e66\u7684\u76ee\u5f55\uff0c\u53ef\u4ee5\u901a\u8fc7\u76ee\u5f55\u5feb\u901f\u67e5\u627e\u6240\u9700\u4fe1\u606f\uff0c\u65e0\u9700\u9605\u8bfb\u6574\u672c\u4e66\u3002<\/span><\/p><br\/><p>&nbsp;<\/p><br\/><p style=\"margin-left: 0px; text-indent: 0px;\">1\u3001<span style=\"font-family: \u5b8b\u4f53;\">\u7d22\u5f15\u7684\u7279\u70b9<\/span><\/p><br\/><p><span style=\"font-family: \u5b8b\u4f53;\">\u9002\u5f53\u5730\u4f7f\u7528\u7d22\u5f15\u53ef\u4ee5\u63d0\u9ad8\u67e5\u8be2\u901f\u5ea6<\/span><\/p><br\/><p><span style=\"font-family: \u5b8b\u4f53;\">\u53ef\u4ee5\u5bf9\u8868\u7684\u4e00\u5217\u6216\u591a\u5217\u5efa\u7acb\u7d22\u5f15<\/span><\/p><br\/><p><span style=\"font-family: \u5b8b\u4f53;\">\u5efa\u7acb\u7d22\u5f15\u7684\u6570\u91cf\u6ca1\u6709\u9650\u5236<\/span><\/p><br\/><p><span style=\"font-family: \u5b8b\u4f53;\">\u7d22\u5f15\u9700\u8981\u78c1\u76d8\u5b58\u50a8\uff0c\u53ef\u4ee5\u6307\u5b9a\u8868\u7a7a\u95f4\uff0c\u7531<\/span>oracle<span style=\"font-family: \u5b8b\u4f53;\">\u81ea\u52a8\u7ef4\u62a4<\/span><\/p><br\/><p><span style=\"font-family: \u5b8b\u4f53;\">\u7d22\u5f15\u5bf9\u7528\u6237\u900f\u660e\uff0c\u68c0\u7d22\u65f6\u662f\u5426\u4f7f\u7528\u7d22\u5f15\u7531<\/span>oracle<span style=\"font-family: \u5b8b\u4f53;\">\u81ea\u8eab\u51b3\u5b9a<\/span><\/p><br\/><p>Oracle<span style=\"font-family: \u5b8b\u4f53;\">\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u5728\u8bbf\u95ee\u6570\u636e\u65f6\u4f7f\u7528\u4ee5\u4e0b\u4e09\u79cd\u65b9\u5f0f\uff1a<\/span><\/p><br\/><p style=\"margin-left: 28px;\"><span style=\"font-family: Wingdings;\">n<span style=\"font-size: 9px; font-family: 'Times New Roman'; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; <\/span><\/span><span style=\"font-family: \u5b8b\u4f53;\">\u5168\u8868\u626b\u63cf<\/span><\/p><br\/><p style=\"margin-left: 28px;\"><span style=\"font-family: Wingdings;\">n<span style=\"font-size: 9px; font-family: 'Times New Roman'; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; <\/span><\/span><span style=\"font-family: \u5b8b\u4f53;\">\u901a\u8fc7<\/span>ROWID<span style=\"font-family: \u5b8b\u4f53;\">\uff08\u884c\u5730\u5740\uff0c\u5feb\u901f\u8bbf\u95ee\u8868\u7684\u4e00\u884c\uff09<\/span><\/p><br\/><p style=\"margin-left: 28px;\"><span style=\"font-family: Wingdings;\">n<span style=\"font-size: 9px; font-family: 'Times New Roman'; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; <\/span><\/span><span style=\"font-family: \u5b8b\u4f53;\">\u4f7f\u7528\u7d22\u5f15<\/span><\/p><br\/><p><span style=\"font-family: \u5b8b\u4f53;\">\u5f53\u6ca1\u6709\u7d22\u5f15\u6216\u8005\u4e0d\u9009\u62e9\u4f7f\u7528\u7d22\u5f15\u65f6\u5c31\u7528\u5168\u8868\u626b\u63cf\u7684\u65b9\u5f0f<\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">2.\u7d22\u5f15\u7684\u5206\u7c7b<\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\"><img src=\"..\/..\/upload\/2019_04\/1904032222139919.png\" alt=\"\" \/><\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">\uff081\uff09\u521b\u5efa\u666e\u901a\u7d22\u5f15\uff08B\u6811\u7d22\u5f15\uff09<\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\"><img src=\"..\/..\/upload\/2019_04\/1904032222139920.png\" alt=\"\" \/><\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">\u53c2\u6570\u89e3\u91ca\uff1a<\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">index_name\uff1a\u521b\u5efa\u7d22\u5f15\u7684\u540d\u79f0<br \/><\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">tablename\uff1a\u4e3a\u4e4b\u521b\u5efa\u7d22\u5f15\u7684\u8868\u540d<\/span><\/p><br\/><p><span style=\"font-family: arial, helvetica, sans-serif;\">columnname:\u5728\u5176\u4e0a\u521b\u5efa\u7d22\u5f15\u7684\u5217\u540d\u5217\u8868\uff0c\u53ef\u4ee5\u57fa\u4e8e\u591a\u5217\u521b\u5efa\u7d22\u5f15\uff0c\u5217\u4e4b\u95f4\u7528\u9017\u53f7\u5206\u9694<\/span><\/p><br\/><p><span style=\"font-family: arial, helvetica, sans-serif;\">tablespace:\u4e3a\u7d22\u5f15\u6307\u5b9a\u8868\u7a7a\u95f4<\/span><\/p><br\/><p><span style=\"font-family: arial, helvetica, sans-serif;\">\uff082\uff09\u521b\u5efa\u552f\u4e00\u7d22\u5f15<\/span><\/p><br\/><p><span style=\"font-family: arial, helvetica, sans-serif;\">\u4fdd\u8bc1\u5b9a\u4e49\u7d22\u5f15\u7684\u5217\u4e2d\u6ca1\u6709\u4efb\u4f55\u4e24\u884c\u6709\u91cd\u590d\u503c\u3002\u552f\u4e00\u7d22\u5f15\u4e2d\u7684\u7d22\u5f15\u5173\u952e\u5b57\u53ea\u80fd\u6307\u5411\u8868\u4e2d\u7684\u4e00\u884c\u3002<br \/><\/span><\/p><br\/><p><span style=\"font-family: arial, helvetica, sans-serif;\"><img src=\"..\/..\/upload\/2019_04\/1904032222139921.png\" alt=\"\" \/><\/span><\/p><br\/><p><span style=\"font-family: arial, helvetica, sans-serif;\">\uff083\uff09\u521b\u5efa\u53cd\u5411\u952e\u7d22\u5f15<\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\"><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\">\u4e0e\u5e38\u89c4<\/span><span style=\"font-size: 14px; font-family: Calibri, sans-serif;\">B<\/span><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\">\u6811\u7d22\u5f15\u76f8\u53cd\uff0c\u53cd\u5411\u952e\u7d22\u5f15\u5728\u4fdd\u6301\u5217\u987a\u5e8f\u7684\u540c\u65f6\u53cd\u8f6c\u7d22\u5f15\u5217\u7684\u5b57\u8282\u3002\u53cd\u5411\u952e\u7d22\u5f15\u901a\u8fc7\u53cd\u8f6c\u7d22\u5f15\u952e\u7684\u6570\u636e\u503c\uff0c\u4f7f\u5f97\u7d22\u5f15\u7684\u4fee\u6539\u5e73\u5747\u5206\u5e03\u5230\u6574\u4e2a\u7d22\u5f15\u6811\u4e0a\u3002\u4e3b\u8981\u5e94\u7528\u4e8e\u6240\u591a\u4e2a\u5b9e\u4f8b\u540c\u65f6\u8bbf\u95ee\u4e00\u4e2a\u6570\u636e\u5e93\u7684\u573a\u666f\u4e2d\u3002<\/span><\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\"><img src=\"..\/..\/upload\/2019_04\/1904032222139922.png\" alt=\"\" \/><\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\">\uff084\uff09\u521b\u5efa\u4f4d\u56fe\u7d22\u5f15<br \/><\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\">\u4f18\u70b9\uff1a\u76f8\u5bf9\u4e8eB\u6811\u7d22\u5f15\u800c\u8a00\uff0c\u57fa\u4e8e\u4f4d\u56fe\u7d22\u5f15\u5217\u7684\u67e5\u8be2\u53ef\u4ee5\u51cf\u5c11\u54cd\u5e94\u65f6\u95f4\u3002<\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\">&nbsp; &nbsp; \u76f8\u6bd4\u5176\u4ed6\u7d22\u5f15\u6280\u672f\uff0c\u4f4d\u56fe\u7d22\u5f15\u5360\u7528\u7a7a\u95f4\u660e\u663e\u51cf\u5c11\u3002<\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\"><img src=\"..\/..\/upload\/2019_04\/1904032222139924.png\" alt=\"\" \/><\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\"><img src=\"..\/..\/upload\/2019_04\/1904032222139923.png\" alt=\"\" \/><\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\">\uff085\uff09\u5176\u4ed6\u7d22\u5f15<br \/><\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\">\u7ec4\u5408\u7d22\u5f15\uff1a\u5728\u8868\u5185\u591a\u5217\u4e0a\u521b\u5efa\u3002\u7d22\u5f15\u4e2d\u7684\u5217\u4e0d\u5fc5\u4e0e\u8868\u4e2d\u7684\u5217\u987a\u5e8f\u4e00\u81f4\uff0c\u4e5f\u4e0d\u5fc5\u76f8\u4e92\u90bb\u63a5\u3002<\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\">\u57fa\u4e8e\u51fd\u6570\u7684\u7d22\u5f15\uff1a<span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\">\u9700\u8981\u521b\u5efa\u7684\u7d22\u5f15\u9700\u8981\u4f7f\u7528\u8868\u4e2d\u4e00\u5217\u6216\u591a\u5217\u7684\u51fd\u6570\u6216\u8868\u8fbe\u5f0f\uff0c\u4e5f\u53ef\u4ee5\u5c06\u57fa\u4e8e\u51fd\u6570\u7684\u7d22\u5f15\u521b\u5efa\u4e3a<\/span><span style=\"font-size: 14px; font-family: 'Calibri','sans-serif';\">B<\/span><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\">\u6811\u7d22\u5f15\u6216\u4f4d\u56fe\u7d22\u5f15<\/span><\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\"><img src=\"..\/..\/upload\/2019_04\/1904032222139925.png\" alt=\"\" \/><\/span><\/p><br\/><p>&nbsp;<\/p><br\/><p style=\"background: white; margin: 10px 0px; text-indent: 0px;\"><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">3\u3001<span style=\"font-size: 16px;\">\u521b\u5efa\u7d22\u5f15\u7684\u539f\u5219<\/span><\/span><\/p><br\/><p style=\"background: white; margin: 10px 0px 10px 28px;\"><span style=\"font-size: 16px; font-family: \u5b8b\u4f53;\">\u9891\u7e41\u641c\u7d22\u7684\u5217\u53ef\u4ee5\u4f5c\u4e3a\u7d22\u5f15\u5217<\/span><\/p><br\/><p style=\"background: white; margin: 10px 0px 10px 28px;\"><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">\u7ecf\u5e38\u6392\u5e8f\uff0c\u5206\u7ec4\u7684\u5217\u53ef\u4ee5\u4f5c\u4e3a\u7d22\u5f15<\/span><\/p><br\/><p style=\"background: white; margin: 10px 0px 10px 28px;\"><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\"><span style=\"font-size: 16px;\">\u7ecf\u5e38\u7528\u4f5c\u8fde\u63a5\u7684\u5217\uff08\u4e3b\u952e<\/span>\/<span style=\"font-size: 16px;\">\u5916\u952e\uff09\u53ef\u4ee5\u4f5c\u4e3a\u7d22\u5f15<\/span><\/span><\/p><br\/><p style=\"background: white; margin: 10px 0px 10px 28px;\"><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">\u5c06\u7d22\u5f15\u653e\u5728\u4e00\u4e2a\u5355\u72ec\u7684\u8868\u7a7a\u95f4\u4e2d\uff0c\u4e0d\u8981\u653e\u5728\u6709\u56de\u9000\u6bb5\u3001\u4e34\u65f6\u6bb5\u548c\u8868\u7684\u8868\u7a7a\u95f4\u4e2d<\/span><\/p><br\/><p style=\"background: white; margin: 10px 0px 10px 28px;\"><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\"><span style=\"font-size: 16px; font-family: \u5b8b\u4f53;\">\u5bf9\u4e8e\u5927\u578b\u7d22\u5f15\u800c\u8a00\uff0c\u8003\u8651\u4f7f\u7528<\/span>NOLOGIN<span style=\"font-size: 16px; font-family: \u5b8b\u4f53;\">\u5b50\u53e5\u521b\u5efa\u5927\u578b\u7d22\u5f15\u3002<\/span><\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">&nbsp; &nbsp; &nbsp; \u6839\u636e\u4e1a\u52a1\u6570\u636e\u53d1\u751f\u9891\u7387\uff0c\u5b9a\u671f\u91cd\u65b0\u751f\u6210\u6216\u91cd\u65b0\u7ec4\u7ec7\u7d22\u5f15\uff0c\u8fdb\u884c\u788e\u7247\u6574\u7406<\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\"><br \/><\/span>4.\u67e5\u770b\u7d22\u5f15<\/p><br\/><p>\u548c\u7d22\u5f15\u6709\u5173\u7684\u6570\u636e\u5b57\u5178\uff1a<\/p><br\/><p>USER_INDEXS\uff1a\u7528\u6237\u521b\u5efa\u7684\u7d22\u5f15\u4fe1\u606f<\/p><br\/><p>USER_IND_COLUMNS\uff1a\u4e0e\u7d22\u5f15\u76f8\u5173\u7684\u8868\u5217\u4fe1\u606f<\/p><br\/><p><img src=\"..\/..\/upload\/2019_04\/1904032222139926.png\" alt=\"\" \/><\/p><br\/><p>5.\u7ef4\u62a4\u7d22\u5f15<\/p><br\/><p>\uff081\uff09\u91cd\u5efa\u7d22\u5f15<\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">\u7d22\u5f15\u9700\u8981\u7ef4\u62a4\uff0c\u5982\u679c\u5efa\u7acb\u4e86\u7d22\u5f15\u7684\u8868\u4e2d\u6709\u5927\u91cf\u7684\u5220\u9664\u548c\u63d2\u5165\u64cd\u4f5c\uff0c\u4f1a\u4f7f\u5f97\u7d22\u5f15\u5f88\u5927\uff0c\u56e0\u4e3a\u5220\u9664\u64cd\u4f5c\u540e\uff0c\u5220\u9664\u503c\u7684\u7d22\u5f15\u7a7a\u95f4\u4e0d\u80fd\u88ab\u81ea\u52a8\u91cd\u65b0\u4f7f\u7528\uff0c\u5bf9\u4e8e\u5927\u8868\u548cDML\u64cd\u4f5c\u5f88\u9891\u7e41\u7684\u8868\uff0c\u7d22\u5f15\u7684\u7ef4\u62a4\u662f\u5f88\u91cd\u8981\u7684\u3002Oracle\u63d0\u4f9b\u4e86rebuild\u6307\u4ee4\u6765\u91cd\u5efa\u7d22\u5f15\u3002\u4f7f\u7d22\u5f15\u7a7a\u95f4\u53ef\u4ee5\u91cd\u7528\u5220\u9664\u503c\u6240\u5360\u7528\u7684\u7a7a\u95f4\uff0c\u4f7f\u7d22\u5f15\u66f4\u52a0\u7d27\u51d1\u3002<\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\"><img src=\"..\/..\/upload\/2019_04\/1904032222139927.png\" alt=\"\" \/><\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">\uff082\uff09\u5408\u5e76\u7d22\u5f15\u788e\u7247<\/span><\/p><br\/><p><span style=\"font-family: arial, helvetica, sans-serif;\">\u5408\u5e76\u7d22\u5f15\u788e\u7247\u53ef\u4ee5\u91ca\u653e\u90e8\u5206\u78c1\u76d8\u7a7a\u95f4\uff0c\u662f\u7d22\u5f15\u7ef4\u62a4\u7684\u4e00\u79cd\u91cd\u8981\u65b9\u5f0f\uff0c\u4e5f\u662f\u7ef4\u62a4\u78c1\u76d8\u7a7a\u95f4\u7684\u65b9\u5f0f\uff0c\u7c7b\u4f3c\u4e8e\u78c1\u76d8\u788e\u7247\u6574\u7406\uff0c\u628a\u4e0d\u7528\u7684\u7a7a\u95f4\u91ca\u653e\u51fa\u6765\u518d\u5229\u7528\u3002<\/span><\/p><br\/><p><img src=\"..\/..\/upload\/2019_04\/1904032222139928.png\" alt=\"\" \/><\/p><br\/><p>\uff083\uff09\u91cd\u547d\u540d\u7d22\u5f15<\/p><br\/><p><img src=\"..\/..\/upload\/2019_04\/1904032222139929.png\" alt=\"\" \/><\/p><br\/><p>\uff084\uff09\u5220\u9664\u7d22\u5f15<\/p><br\/><p><img src=\"..\/..\/upload\/2019_04\/1904032222139930.png\" alt=\"\" \/><\/p><br\/><p><span style=\"font-size: 24px;\">\u516b\u3001\u89c6\u56fe<\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">\u89c6\u56fe\u662f\u4e00\u4e2a\u865a\u8868\uff0c\u4e0d\u5360\u7528\u7269\u7406\u7a7a\u95f4\uff0c\u56e0\u4e3a\u89c6\u56fe\u672c\u8eab\u7684\u5b9a\u4e49\u8bed\u53e5\u5b58\u50a8\u5728\u6570\u636e\u5b57\u5178\u91cc\uff0c\u89c6\u56fe\u4e2d\u7684\u6570\u636e\u662f\u4e00\u4e2a\u6216\u591a\u4e2a\u5b9e\u9645\u8868\u4e2d\u83b7\u5f97\u7684\u3002\u90a3\u4e9b\u7528\u4e8e\u4ea7\u751f\u89c6\u56fe\u7684\u8868\u53eb\u505a\u8be5\u89c6\u56fe\u7684\u57fa\u8868\u3002\u4e00\u4e2a\u89c6\u56fe\u4e5f\u53ef\u4ee5\u4ece\u53e6\u4e00\u4e2a\u89c6\u56fe\u4e2d\u4ea7\u751f\u3002<\/span><\/p><br\/><p>1\u3001<span style=\"font-family: \u5b8b\u4f53;\">\u89c6\u56fe\u7684\u4f18\u70b9\uff1a<\/span><\/p><br\/><p style=\"margin-left: 28px;\"><span style=\"font-family: arial, helvetica, sans-serif;\">1)<span style=\"font-size: 9px; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; &nbsp; &nbsp; <\/span>\u63d0\u4f9b\u4e86\u53e6\u5916\u4e00\u79cd\u7ea7\u522b\u7684\u8868\u5b89\u5168\u6027<\/span><\/p><br\/><p style=\"margin-left: 28px;\"><span style=\"font-family: arial, helvetica, sans-serif;\">2)<span style=\"font-size: 9px; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; &nbsp; &nbsp; <\/span>\u9690\u85cf\u7684\u6570\u636e\u7684\u590d\u6742\u6027\uff1a\u4e00\u4e2a\u89c6\u56fe\u53ef\u80fd\u662f\u7528\u591a\u8868\u8fde\u63a5\u5b9a\u4e49\u7684\uff0c\u4f46\u7528\u6237\u4e0d\u9700\u8981\u77e5\u9053\u591a\u8868\u8fde\u63a5\u7684\u8bed\u53e5\u4e5f\u53ef\u4ee5\u67e5\u8be2\u6570\u636e\u3002<\/span><\/p><br\/><p style=\"margin-left: 28px;\"><span style=\"font-family: arial, helvetica, sans-serif;\">3)<span style=\"font-size: 9px; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; &nbsp; &nbsp; <\/span>\u7b80\u5316\u7684\u7528\u6237\u7684SQL\u547d\u4ee4\uff1a\u67e5\u8be2\u89c6\u56fe\u7684\u65f6\u5019\u4e0d\u9700\u8981\u5199\u51fa\u590d\u6742\u7684\u67e5\u8be2\u8bed\u53e5\uff0c\u53ea\u9700\u8981\u67e5\u8be2\u89c6\u56fe\u540d\u79f0\u5373\u53ef\u3002<\/span><\/p><br\/><p style=\"margin-left: 28px;\"><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">4)<span style=\"font-size: 16px; line-height: normal; font-stretch: normal; font-variant-numeric: normal;\">&nbsp; &nbsp; &nbsp; <\/span><span style=\"font-size: 16px;\">\u9694\u79bb\u57fa\u8868\u7ed3\u6784\u7684\u6539\u53d8\uff1a\u89c6\u56fe\u521b\u5efa\u597d\u4e86\u4e4b\u540e\uff0c\u5982\u679c\u4fee\u6539\u4e86\u8868\u7684\u7ed3\u6784\uff0c\u4e5f\u4e0d\u4f1a\u5f71\u54cd\u89c6\u56fe\u7684<\/span><\/span><span style=\"font-family: \u5b8b\u4f53;\">\u3002<\/span><\/p><br\/><p><span style=\"font-size: 14px; font-family: \u5b8b\u4f53;\">&nbsp;<span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">&nbsp; &nbsp;5\uff09\u901a\u8fc7\u91cd\u547d\u540d\u5217\uff0c\u4ece\u53e6\u4e00\u4e2a\u89d2\u5ea6\u63d0\u4f9b\u6570\u636e\uff1a\u4f8b\u5982\u5728\u9500\u552e\u7cfb\u7edf\u4e2d\uff0c\u6bcf\u65e5\u4e0b\u73ed\u524d\u8981\u5bf9\u5f53\u65e5\u6570\u636e\u8fdb\u884c\u6c47\u603b\uff0c\u5728\u9500\u552e\u4eba\u5458\u773c\u4e2d\uff0c\u8be5\u6c47\u603b\u8868\u6210\u4e3a\u65e5\u9500\u552e\u7edf\u8ba1\u8868\uff0c\u5728\u8d22\u52a1\u4eba\u773c\u4e2d\uff0c\u8be5\u9500\u552e\u8868\u6210\u4e3a\u9500\u552e\u65e5\u62a5\u8868<\/span><\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">2.\u521b\u5efa\u89c6\u56fe<\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\"><img src=\"..\/..\/upload\/2019_04\/1904032222139931.png\" alt=\"\" \/><\/span><\/p><br\/><p><span style=\"font-size: 16px; font-family: arial, helvetica, sans-serif;\">\u53c2\u6570\u89e3\u91ca\uff1a<br \/><\/span><\/p><br\/><p>&nbsp;<\/p><br\/><p><span style=\"font-family: arial, helvetica, sans-serif;\">OR REPLACE:\u5982\u679c\u89c6\u56fe\u5df2\u5b58\u5728\uff0c\u6b64\u9009\u9879\u5c06\u91cd\u65b0\u521b\u5efa\u8be5\u89c6\u56fe\u3002<\/span><\/p><br\/><p><span style=\"font-family: arial, helvetica, sans-serif;\">FORC","orderid":"0","title":"Oracle\u6570\u636e\u5e93\u5e38\u7528\u64cd\u4f5c\u547d\u4ee4(\u4e00)","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"329","pages":"3","comments":"0","posttime":"2019-04-04 00:11:39","list":"1554307899","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"<A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=Oracle' target=_blank>Oracle<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%CA%FD%BE%DD%BF%E2' target=_blank>\u6570\u636e\u5e93<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B3%A3%D3%C3' target=_blank>\u5e38\u7528<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B2%D9%D7%F7' target=_blank>\u64cd\u4f5c<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%C3%FC%C1%EE' target=_blank>\u547d\u4ee4<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"47.106.78.186","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"Oracle\u6570\u636e\u5e93\u5e38\u7528\u64cd\u4f5c\u547d\u4ee4","lastview":"1713565950","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}