drop lob object - resolved

I purged the recycle bin and they went away.
++++++++++++++++++
I ran a script to drop all tables, indexes, procedures, etc. owned by a
given user.  I now find that I have 3 lob objects left.  How do I delete
them?
 
SQL> select * from sys.dba_objects where owner='TKCSOWNER';
 
OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- --------------
-------------------
CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S
--------- --------- ------------------- ------- - - -
TKCSOWNER
SYS_LOB0000022266C00019$$
                                    22267          22267 LOB
26-SEP-08 26-SEP-08 2008-09-26:12:33:24 VALID   N Y N
 
TKCSOWNER
SYS_LOB0000022279C00002$$
                                    22280          22280 LOB
26-SEP-08 26-SEP-08 2008-09-26:12:36:52 VALID   N Y N
 
TKCSOWNER
SYS_LOB0000022332C00006$$
                                    22333          22333 LOB
26-SEP-08 26-SEP-08 2008-09-26:12:37:12 VALID   N Y N
 

3 rows selected.
 
SQL>
 
 
Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113

Other related posts: