Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How can I delete/drop these LOBs ?

Test TestdJan 24 2025 — edited Jan 24 2025

I dropped all tables in the below schema with the purge clause like below.

drop table MYAPPSCHEMA.HRMS_CONTACT_DTL cascade constraints PURGE;

But, I still see some LOBs as shown below. It can't be part of the Job which I retained. Right ?
So, how can I get rid of these LOBs ? When you drop tables, the related LOBs also should get dropped, if I am not mistaken.

SQL> select object_name, object_type, CREATED from dba_objects where owner = 'MYAPPSCHEMA';

OBJECT_NAME                                             OBJECT_TYPE        CREATED
------------------------------------------------------- ------------------ -----------------
HRMSGT3_WO58654                                         JOB                20211009 21:39:24
SYS_LOB0000239415C00003$$                               LOB                20240115 22:58:10
SYS_LOB0000239415C00005$$                               LOB                20240115 22:58:10
This post has been answered by Solomon Yakobson on Jan 24 2025
Jump to Answer
Comments
Post Details
Added on Jan 24 2025
5 comments
88 views