Hello Tom

According to
https://docs.oracle.com/database/121/ADLOB/adlob_smart.htm#ADLOB46175

basicfile lob must be stored in a tablespace with segment space manually managed. However, it seems oracle does not prevent user from creating it in an ASSM tablespace:


SQL> select tablespace_name,segment_space_management from dba_tablespaces where tablespace_name = 'AUTOTS';

TABLESPACE_NAME SEGMEN
------------------------------ ------
AUTOTS AUTO


SQL> create table testlob1 (
ID number,
DATA CLOB
) tablespace users
lob(data) store as basicfile (
tablespace autots
);

Table created.

So is there any reason basicfile LOB should not be used with ASSM?