// ²¼³¬ÁØÍѥƥó¥×¥ì¡¼¥È #topicpath ---- //¤³¤³¤Ë¥³¥ó¥Æ¥ó¥Ä¤òµ½Ò¤·¤Þ¤¹¡£ #contents Oracle¤Ï¤Û¤È¤ó¤ÉÃΤé¤Ê¤¤¤Î¤Ç¡¢¤È¤ê¤¢¤¨¤ºÈ÷˺¡£ **¥´¥ß¥Æ¡¼¥Ö¥ë¤Îºï½ü [#p044b50d] purge user_recyclebin; **SQL*Plus¤ÎTIPS [#e895e9d8] ***³°Éô¥Õ¥¡¥¤¥ë¤«¤éSQL¼Â¹Ô [#g41782bf] sqlplus user/pass @hogehoge.sql ¤Çhogehoge.sql¤ÎSQL¤¬¼Â¹Ô¤Ç¤¤ë ***hogehoge.sql¤Îʸˡ [#jef18876] -SQL*Plus¤Ï¤É¤¦¤â°ì¥«¥é¥à¤¢¤¿¤ê¤ÎÉý¤¬¶¹¤¯¡¢¤¹¤°¤ËÀÞ¤êÊÖ¤·¤Á¤ã¤¦¡£ set linesize 9999 ¤Ç²£¤Ë¤É¡¼¤ó¤È¹¤¤É½¼¨¤Ë¤Ê¤ë¡£¡£ -SQL*Plus¤Ï¤¹¤°¤Ë¥Ø¥Ã¥À(¥«¥é¥à̾)¤òÁÞÆþ¤·¤Á¤ã¤¦¡£ set pagesize 10000 ¤È¤«¤Ç¥Ø¥Ã¥À¤òÁÞÆþ¤·¤Ê¤¤¤è¤¦¤Ë¤¹¤ë -¥Õ¥¡¥¤¥ë¤Ë½ñ¤½Ð¤¹ÊýË¡¡£¤É¤¦¤âhogehoge.sql¤Ç spool result.txt SQLʸ¡£ spool off exit ¤È¤¹¤ë¤È½ÐÎÏ·ë²Ì¤ò¥Õ¥¡¥¤¥ë¤Ë½ñ¤½Ð¤¹¤ß¤¿¤¤¡£ ***SQL*Plus¤ÈTeraTerm¤Çüâ¤Ê¤É¤¬Ê¸»ú²½¤±¤¹¤ë [#mb64a834] DB¤Îʸ»ú¥³¡¼¥É¤òJA16SJISTILDE¤È¤·¤Æ¤¤¤ë¤È¤¡¢TerraTerm¤Çselect¤·¤Æ¤ß¤ë¤Èü⤬ʸ»ú²½¤±¤·¤Æ¤¿¡£¡£ export NLS_LANG=Japanese_Japan.JA16SJISTILDE ¤È¤·¤Æ´Ä¶ÊÑ¿ô¤òÀßÄꤷ¡¢¤µ¤é¤ËTeraTerm¤òSJIS¤Ë¤·¤Æ¤ª¤±¤ÐOK¤Ç¤¹¡£ ***¥æ¡¼¥¶¤Îºï½ü [#i8c0fe81] SQL> drop user hogehoge cascade; ---- ¤³¤Îµ»ö¤Ï #vote(¤ª¤â¤·¤í¤«¤Ã¤¿,¤½¤¦¤Ç¤â¤Ê¤¤) #comment #topicpath SIZE(10){¸½ºß¤Î¥¢¥¯¥»¥¹:&counter;}