Prevent disk space issues during ASCP plan run

ASCP plan is one of the most likely things which fails after a fresh clone from Production. Most of the time it is due to space issues. Tablespaces which are populated during the plan run should be pre-checked for free space with this query (Run this on both OLTP (source) and ASCP(destination) instance):

select ts.tablespace_name, to_char(sum(nvl(fs.bytes,0))/1048576, '99,999,990.99') as MB_FREE,
count(*) as FRAGMENTS, to_char(max(nvl(fs.bytes,0))/1048576, '99,999,990.99') as BIGGEST_BIT
from dba_free_space fs, dba_tablespaces ts
where fs.tablespace_name(+) = ts.tablespace_name
and ts.tablespace_name in ('INVD','INVX','WSHD','WSHX','BOMD','BOMX','ONTD','ONTX','WSMD','WSMX',
'MRPD','MRPX','AHLD','AHLX','WIPD','WIPX','POD','POX')
group by ts.tablespace_name
/
TABLESPACE_NAME MB_FREE FRAGMENTS BIGGEST_BIT
------------------ -------------- ---------- --------------
AHLD 37.54 1 37.54
AHLX 5.12 1 5.12
BOMD 90,125.31 1339 1,225.20
BOMX 86,136.33 3677 914.88
INVD 1,344.96 3031 554.26
INVX 3,642.46 252 1,218.16
MRPD 7,521.95 322 228.24
MRPX 10,800.98 1226 845.20
ONTD 2,370.04 975 1,947.34
ONTX 1,222.62 2036 792.23
POD 13,663.32 2256 516.17
POX 1,881.17 1002 639.84
WIPD 177.07 2 176.99
WIPX 69.06 4 67.42
WSHD 3,369.14 96 1,625.55
WSHX 3,455.78 435 1,196.25
WSMD 181.41 1 181.41
WSMX 78.79 1 78.79

18 rows selected.

Add space to all the tablespaces where MB_FREE shows less than 200 MB. I usually advise adding a new 2GB datafile to each tablespace which has less than 200 MB. If you do not add space, plan may fail with these errors in a non-OATM instance:

Altering Snapshot : WIP_FLOW_SCHDS_SN
Index WIP_FLOW_SCHDS_SN_N1 does not exist...
ORA-01658: unable to create INITIAL extent for segment in tablespace WIPX
ORA-20001: Index Creation failed: ORA-01658: unable to create INITIAL extent for segment in tablespace WIPX

Also run this query:

select sum(bytes)/1024/1024/1024 from v$tempfile;

Result of the above query should be greater than or equal to 12

Which means you should have at least 12 GB of space in temp files for the plan to succeed.