Oracle Database Discussions

Good evening,

I am learning Oracle 11gR2 (I'm a beginner). If I log in as SYSTEM and run the following script:

drop table table123;

create table table123 (t varchar2(10));

select tablespace_name, segment_name from dba_extents where segment_name like 'TABLE%';

I get (as expected) the following output:

TABLESPACE_NAME                SEGMENT_NAME
------------------------------ ----------------------------------------
SYSTEM                         TABLE_PRIVILEGE_MAP
SYSTEM                         TABLE123
EXAMPLE                        TABLE2
EXAMPLE                        TABLE1

still logged in as SYSTEM I drop the table using:

drop table table123;

Now I go to a different session where I am logged in as a different user (but the user has been granted everything there is) and I do the same thing I did as SYSTEM (that is run the first script shown above) and the result is different (the segment name for TABLE123 is missing) as shown in the output below:

TABLESPACE_NAME                SEGMENT_NAME
------------------------------ --------------------
SYSTEM                         TABLE_PRIVILEGE_MAP
EXAMPLE                        TABLE2
EXAMPLE                        TABLE1

I cannot figure out why the segment for TABLE123 is missing yet, the very same script was run. The only difference is the user but since this user has as many capabilities as SYSTEM itself I don't see how the user makes a difference in this case.

The question is: What happened to TABLE123, why isn't it showing in the second output ?

Thank you for your help,

John.