´ËÎÊÌâÈçºÎÓ¦¸¶£¿<oracle>

ÔÚPL/SQLÖÐн¨Á˱ít_user£¬µ±ÎÒdropµô´Ë±íµÄʱºò»á×Ô¶¯Ð½¨Ò»¸ö±í"bin$2kra8srpshg4p55iydqqfq==$0"£¬±í½á¹¹ºÍt_userÒ»ÃþÒ»Ñù£¬Êý¾ÝÒ²ÊÇÒ»ÑùµÄ£¿´Ë±íº¬ÓÐÌØÊâ×Ö·ûɾ³ý²»ÁË...ÈçºÎ½«ÕâÕűíɾ³ýµô£¿£¿£¿ÕâÕűíÊÇÈçºÎÀ´µÄßÖ£¿±¸·Ý£¿»¹ÊÇ£¿Çë½Ì¸ßÊÖ£¡

---

oracle10g»ØÊÕÕ¾¹¦ÄÜ

purge user_recyclebin;

¼´¿ÉÇå³ý¡£

SQL> create table test (id number);

±íÒÑ´´½¨¡£

SQL> drop table test;

±íÒÑɾ³ý¡£

SQL> select object_name from user_recyclebin;

OBJECT_NAME
------------------------------
BIN$0JO6kztISjCcvfEZNU843g==$0

SQL> purge user_recyclebin;

»ØÊÕÕ¾ÒÑÇå¿Õ¡£

SQL> select object_name from user_recyclebin;

δѡ¶¨ÐÐ

SQL>

---

Èç¹ûÏ£Íûɾ³ý±íÊDz»·Å»ØÊÕÕ¾£¬ÔòʹÓãº
drop table table_name purge;

Ï൱ÓÚwindowsµÄshift+delete¡£

---

Â¥ÉÏÕý½â

---

purge user_recyclebin;

---

ѧϰÁË£¬ºÇºÇ£¡

---

Èç¹ûÏ£Íûɾ³ý±íÊDz»·Å»ØÊÕÕ¾£¬ÔòʹÓãº
drop table table_name purge;

Ï൱ÓÚwindowsµÄshift+delete¡£


Õý½â

---

10g²ÅÓеŦÄÜ

---

ÒýÓÃ

oracle10g»ØÊÕÕ¾¹¦ÄÜ

purge user_recyclebin;

¼´¿ÉÇå³ý¡£

SQL> create table test (id number);

±íÒÑ´´½¨¡£

SQL> drop table test;

±íÒ