LOB object drop error

[getnami]

Hi,

In the process of refreshing a schema, I have already dropped the columns from LOB table.
Then I tried dropping the rest of the objects, but few objects of type LOB are not getting dropped and I am receiving the below error:

drop LOB ABC.SYS_LOB0000435014C00002$$
*
ERROR at line 1:
ORA-00950: invalid DROP option

(Here LOB-> object type and ABC- owner)

Can someone please help in resolving the same and what could be its affect on the refresh.


Thanks in advance
Regards,
Aakriti

[PAVB]

There is not such a command as drop lob.

LOBs are datatypes, datatypes for columns that are stored into tables so you can delete rows and truncate tables.

If what you want is to get rid of physical files you have to purge.

[getnami]

Hi,

I have dropped the LOB objects by dropping the column of the LOB_table.
Then tried dropping the objects of the schema, wherein encountered this error.
Also, purged the recyclebin, yet receiving the same error.

I hope its more understandable now. Any help please.

Thanks in advance

Regards,

[mayura.ch]

can you do "purge dba_recyclebin;" and check.

Regards...Mayura

[davey23uk]

Hi,

I have dropped the LOB objects by dropping the column of the LOB_table.
Then tried dropping the objects of the schema, wherein encountered this error.
Also, purged the recyclebin, yet receiving the same error.

I hope its more understandable now. Any help please.

Thanks in advance

Regards,

receiving what error, what exactly are you trying to do?