page152
135
failsafe_GB,
retained_for_clone_GB
FROM v_table_storage_metrics
WHERE path_to_object = 'TPC.TPC_OWNER.PARTSUPP_BASELINE';
Figure 4-13 shows the expected result. Only
active_GB
storage is allocated.
Figure 4-13.
partsupp_baseline active storage
You now clone
partsupp_baseline
to
partsupp_baseline_clone
.
CREATE TABLE tpc.tpc_owner.partsupp_baseline_clone
CLONE tpc.tpc_owner.partsupp_baseline;
Now re-check consumed storage for both the parent and child tables.
SELECT path_to_object,
active_GB,
time_travel_GB,
failsafe_GB,
retained_for_clone_GB
FROM v_table_storage_metrics
WHERE path_to_object IN
( 'TPC.TPC_OWNER.PARTSUPP_BASELINE',
'TPC.TPC_OWNER.PARTSUPP_BASELINE_CLONE' );
The results should be identical to Figure 4-13 as shown indicating no additional
storage has been allocated for
partsupp_baseline_clone
.
automatic clustering is suspended for cloned tables.
ChaPTer 4
MiCro-ParTiTionS