Migration

 Migration

select  count(1),segment_type from dba_segments where tablespace_name='LOB_NEW' group by segment_type;

SELECT TABLE_OWNER,TABLE_NAME,COLUMN_NAME,LOB_NAME,PARTITION_NAME,LOB_PARTITION_NAME,SECUREFILE,TABLESPACE_NAME

FROM DBA_LOB_PARTITIONS 

WHERE TABLE_OWNER = 'CCUSER' 

AND TABLESPACE_NAME = 'LOB'

AND TABLE_NAME = 'CC_MESSAGE';

select 'ALTER TABLE '||TABLE_OWNER||'.'||TABLE_NAME||' MOVE PARTITION '||partition_name||' LOB ('||column_name||') STORE AS BASICFILE (TABLESPACE LOB_NEW) parallel 32;' from 

DBA_LOB_PARTITIONS 

WHERE TABLE_OWNER = 'CCUSER' 

AND TABLESPACE_NAME = 'LOB'

AND TABLE_NAME = 'CC_MESSAGE';

select 'ALTER TABLE ' || OWNER || '.' || TABLE_NAME || ' MOVE TABLESPACE PROD_DATA;' from DBA_TABLES WHERE OWNER ='PROD';

select 'ALTER INDEX ' || OWNER || '.'|| index_name ||' rebuild tablespace INDX_TB online;' from dba_indexes where owner='PROD';

can you try this :

create tablespace lepdata 
datafile '+p1rac1d4_oradata' size 20g
logging
online
permanent
blocksize 8192
extent management local autoallocate
default nocompress
segment space management auto;

Course URL: - https://learn.microsoft.com/en-us/training/courses/AZ-104T00?WT.mc_id=ilt_partner_webpage_wwl&ocid=4428290&DCS=DEPR2340032#study-guide 

Achievement Code URL: - https://learn.microsoft.com/en-us/users/me/achievements?redeem=RDG8DZ&WT.mc_id=ilt_partner_webpage_wwl&ocid=4428290&DCS=DEPR2340032

https://ind01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fforms.office.com%2Fr%2FNx5dy3JiLW&data=05%7C01%7CRM00759529%40TechMahindra.com%7C465303814e924bfb158708db1b1939f9%7Cedf442f5b9944c86a131b42b03a16c95%7C0%7C0%7C638133567383492233%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=C%2FAc9WeKaVKB0QRGjFuk0x%2B6WZQRRgrrrjtKsJJtwkY%3D&reserved=0