drop lob object - resolved
- From: "Jeffrey Beckstrom" <JBECKSTROM@xxxxxxxxx>
- To: "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>, "oracle-db-l" <oracle-db-l@xxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 29 Sep 2008 10:11:24 -0400
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:
- » drop lob object - resolved
