Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: I have trouble with RECYCLE-BIN in 10g
1 select OWNER, SEGMENT_NAME , TABLESPACE_NAME from dba_segments
2* where segment_name = 'TEST_TABLE7'
SQL> /
OWNER
TABLESPACE_NAME EXTENT_MAN
------------------------------ ----------
SYSTEM DICTIONARY TEMP LOCAL RBS DICTIONARY DATA01 LOCAL INDEX01 LOCAL SYSAUX LOCAL UNDO_TBS1 LOCAL
7 rows selected.
SQL> show parameters compat
NAME TYPE VALUESQL> And then I login as my ddduser(test user): SQL> select * from test_table7;
------------------------------------ -----------
------------------------------
compatible string 9.2.0 plsql_v2_compatibility boolean FALSE
ID NAME SALARY ---------- ------------------------------ ---------- 1 name 111 12340 2 name 222 22340 3 name 333 33340 4 name 444 44440 5 name 555 55550
SQL>
SQL> show user;
USER is "DDDUSER"
SQL> drop table test_table7;
Table dropped.
SQL> select * from recyclebin;
no rows selected
I still don't get it,
There is nothing in my recyclebin:
And my initINSTANCE_NAME.ora has this line:
*.compatible='10.1.0'# change for upgrade
I don't get it.
I still has NOTHING in my recyclebin??? Received on Wed Feb 08 2006 - 12:46:00 CST