Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: I have trouble with RECYCLE-BIN in 10g

Re: I have trouble with RECYCLE-BIN in 10g

From: <dominica_at_gmail.com>
Date: 8 Feb 2006 10:46:00 -0800
Message-ID: <1139424360.530321.78080@g43g2000cwa.googlegroups.com>


 1 select OWNER, SEGMENT_NAME , TABLESPACE_NAME from dba_segments   2* where segment_name = 'TEST_TABLE7'
SQL> / OWNER



SEGMENT_NAME

TABLESPACE_NAME

DDDUSER
TEST_TABLE7
DATA01 SQL> select TABLESPACE_NAME, EXTENT_MANAGEMENT from dba_tablespaces;
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        VALUE

------------------------------------ -----------
------------------------------
compatible string 9.2.0 plsql_v2_compatibility boolean FALSE
SQL> And then I login as my ddduser(test user): SQL> select * from test_table7;
        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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US