Drop partitioned table [message #320268] |
Wed, 14 May 2008 08:40  |
TLegend33
Messages: 203 Registered: March 2005
|
Senior Member |
|
|
I created a test partitioned table, added an index and then dropped the table:
SQL> drop table test2;
table dropped.
When I query user_segments, I'm displayed the below:
SQL> select segment_name, partition_name, segment_type, bytes/1024/1024 from user_segments where segment_name like 'BIN%';
SEGMENT_NAME PARTITION_NAME SEGMENT_TYPE BYTES/1024/1024
------------------------------ ------------------------------ ------------------ ---------------
BIN$TSLtIoCBK4jgRAADunJ3VQ==$0 TABLE 9728
BIN$TKW4kMkZbZPgRAADunJ3VQ==$0 TABLE 1
BIN$TKW4kMkabZPgRAADunJ3VQ==$0 TABLE 1
BIN$TKW4kMkbbZPgRAADunJ3VQ==$0 TABLE 1
BIN$TSLtIoB/K4jgRAADunJ3VQ==$0 TABLE 1
BIN$TSLtIoCCK4jgRAADunJ3VQ==$0 SAT_P200701 TABLE PARTITION 1
BIN$TSLtIoCCK4jgRAADunJ3VQ==$0 SAT_P200702 TABLE PARTITION 1
BIN$TSLtIoCCK4jgRAADunJ3VQ==$0 SAT_P200703 TABLE PARTITION 1
BIN$TSLtIoCAK4jgRAADunJ3VQ==$0 INDEX 4608
Did my table not drop correctly? I'm not really sure what I'm looking at here.
Thanks.
|
|
|
|
|