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>
OBJECT_NAME
SYS_LOB0000022266C00019$$
SYS_LOB0000022279C00002$$
SYS_LOB0000022332C00006$$
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_TYPETKCSOWNER
------------------------------ ---------- --------------
-------------------
CREATED LAST_DDL_ TIMESTAMP STATUS T G S
--------- --------- ------------------- ------- - - -
SYS_LOB0000022266C00019$$
22267 22267 LOB26-SEP-08 26-SEP-08 2008-09-26:12:33:24 VALID N Y N TKCSOWNER
SYS_LOB0000022279C00002$$
22280 22280 LOB26-SEP-08 26-SEP-08 2008-09-26:12:36:52 VALID N Y N TKCSOWNER
SYS_LOB0000022332C00006$$
22333 22333 LOB26-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