drop lob object

From: Jeffrey Beckstrom <JBECKSTROM_at_gcrta.org>
Date: Mon, 29 Sep 2008 10:09:21 -0400
Message-Id: <48E0A950.3406.000B.0@gcrta.org>


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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Sep 29 2008 - 09:09:21 CDT

Original text of this message