show recyclebin怎么没有任何东西？

显示全部楼层 · 2007-8-24 01:03:22

删除了表后！

千问 · 2007-8-24 01:03:22

用户有没有切换过？

千问 · 2007-8-24 01:03:22

切换了，而且recyclebin是on的状态。

千问 · 2007-8-24 01:03:22

SYS.YUDONG>SELECT OBJECT_NAME,ORIGINAL_NAME FROM DBA_RECYCLEBIN;
OBJECT_NAME
ORIGINAL_NAME
------------------------------ --------------------------------
BIN$OLKJZUOrQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_USER$
BIN$OLKJZUOpQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_TYPE$
BIN$OLKJZUOnQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_TS$
BIN$OLKJZUOlQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_TABSUBPART$
BIN$OLKJZUOjQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_TABPART$
BIN$OLKJZUOhQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_TABCOMPART$
BIN$OLKJZUOfQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_TAB$
BIN$OLKJZUOdQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_SEED$
BIN$OLKJZUObQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_OBJ$
BIN$OLKJZUOZQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_LOBFRAG$
BIN$OLKJZUOXQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_LOB$
BIN$OLKJZUOVQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_INDSUBPART$
BIN$OLKJZUOTQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_INDPART$
BIN$OLKJZUORQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_INDCOMPART$
BIN$OLKJZUOPQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_IND$
BIN$OLKJZUONQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_ICOL$
BIN$OLKJZUOLQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_DICTIONARY$
BIN$OLKJZUOJQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_COLTYPE$
BIN$OLKJZUOHQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_COL$
BIN$OLKJZUOFQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_CDEF$
BIN$OLKJZUOBQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_ATTRIBUTE$
BIN$OLKJZUN/Q3XgQAgKK+JKWg==$0 LOGMNRLT_101_ATTRCOL$
BIN$OLKJZUODQ3XgQAgKK+JKWg==$0 LOGMNRLT_101_CCOL$
BIN$D7kQpOqoSSTgQAgKQOhfJQ==$0 TB020
BIN$D7kQpOqlSSTgQAgKQOhfJQ==$0 A
BIN$D7kQpOqkSSTgQAgKQOhfJQ==$0 B

千问 · 2007-8-24 01:03:22

在SYSTEM表空间下面，DROP后改对象不进RECYCLEBIN.

SYS.YUDONG>ALTER USER SYSTEM IDENTIFIED BY SYSTEM ;
User altered.
SYS.YUDONG>CONN SYSTEM/SYSTEM
Connected.

1 row selected.
SYSTEM.YUDONG>CREATE TABLE T(ID INT);
CREATE TABLE T(ID INT)

*
ERROR at line 1:
ORA-00955: name is already used by an existing object

SYSTEM.YUDONG>CREATE TABLE TT(ID INIT);
CREATE TABLE TT(ID INIT)

*
ERROR at line 1:
ORA-00902: invalid datatype

SYSTEM.YUDONG>CREATE TABLE TT(ID INTEGER);
Table created.
SYSTEM.YUDONG>DESC TT;
Name
Null?Type
----------------------------------------------------------------------------- -------- ----------------------------------------------------
ID
NUMBER(38)
SYSTEM.YUDONG>DROP TABLE TT;
Table dropped.
SYSTEM.YUDONG>SELECT OBJECT_NAME,ORIGINAL_NAME FROM USER_RECYCLEBIN;
no rows selected

千问 · 2007-8-24 01:03:22

周同学，看来你不错啊。哈哈。
常常上来啊。

千问 · 2007-8-24 01:03:22

不是system用户啊。是普通用户啊。

千问 · 2007-8-24 01:03:22

https://www.cnblogs.com/lfree/p/15042428.html
估计与我遇到的一样.