环境：windows  oracle 12.2.0.1 单机

1. 创建lob 表

create user c##t1 identified by t1;

grant dba to c##t1;

conn c##t1/t1

create table lobtest(a varchar2(20), b clob, c blob) tablespace users;

insert into lobtest values('xiao','this is a good',empty_blob());

CREATE INDEX IDX_LOB ON LOBTEST(A);

2.move 前

SQL> select  OWNER,OBJECT_NAME , DATA_OBJECT_ID from dba_objects where OWNER='C##T1';

OWNER    OBJECT_NAME     DATA_OBJECT_ID

---------- ---------------------------------------- --------------

C##T1    LOBTEST      23336

C##T1    SYS_IL0000023319C00003$$       23332

C##T1    SYS_LOB0000023319C00003$$      23331

C##T1    SYS_IL0000023319C00002$$       23330

C##T1    SYS_LOB0000023319C00002$$       23329

C##T1    IDX_LOB

6 rows selected.

3.move online

SQL> alter table lobtest move online;

Table altered.

SQL>  select  OWNER,OBJECT_NAME , DATA_OBJECT_ID from dba_objects where OWNER='C##T1';

OWNER    OBJECT_NAME     DATA_OBJECT_ID

---------- ---------------------------------------- --------------

C##T1    LOBTEST      23337

C##T1    SYS_IL0000023319C00003$$       23344

C##T1    SYS_LOB0000023319C00003$$       23343

C##T1    SYS_IL0000023319C00002$$      23342

C##T1    SYS_LOB0000023319C00002$$       23341

C##T1    IDX_LOB      23347

SQL>  alter table lobtest move;

Table altered.

SQL> select  OWNER,OBJECT_NAME , DATA_OBJECT_ID from dba_objects where OWNER='C##T1';

OWNER    OBJECT_NAME     DATA_OBJECT_ID

---------- ---------------------------------------- --------------

C##T1    LOBTEST      23361

C##T1    SYS_IL0000023319C00003$$       23344

C##T1    SYS_LOB0000023319C00003$$       23343

C##T1    SYS_IL0000023319C00002$$       23342

C##T1    SYS_LOB0000023319C00002$$       23341

C##T1    IDX_LOB      23347

由上面的测试可知：move加online则会移动lob，不加不移动。