Home » SQL & PL/SQL » SQL & PL/SQL » Drop partitioned table (Oracle DB 10.2.0.1 SUN SPARC OS)
Drop partitioned table [message #320268] Wed, 14 May 2008 08:40 Go to next message
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.
Re: Drop partitioned table [message #320273 is a reply to message #320268] Wed, 14 May 2008 08:49 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
> I'm not really sure what I'm looking at here.
These segments are now in the Recycle bin.
Re: Drop partitioned table [message #320276 is a reply to message #320273] Wed, 14 May 2008 08:52 Go to previous message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
Ah, thank you very much.
Previous Topic: tuning a sql
Next Topic: Retriving Package
Goto Forum:
  


Current Time: Wed Dec 07 10:33:55 CST 2016

Total time taken to generate the page: 0.20548 seconds