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.