FAQ
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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedSep 29, '08 at 2:11p
activeSep 29, '08 at 2:11p
posts1
users1
websiteoracle.com

1 user in discussion

Jeffrey Beckstrom: 1 post

People

Translate

site design / logo © 2022 Grokbase