Estimate space required for index creation

SET SERVEROUTPUT ON
DECLARE
v_used_bytes NUMBER(10);
v_Allocated_Bytes NUMBER(10);
BEGIN
DBMS_SPACE.CREATE_INDEX_COST
( ‘
create index PROD.INDEX1 on PROD.EMP(EMPNO)’,
v_used_Bytes,
v_Allocated_Bytes
); DBMS_OUTPUT.PUT_LINE(‘Used Bytes MB: ‘ || round(v_used_Bytes/1024/1024));
DBMS_OUTPUT.PUT_LINE(‘Allocated Bytes MB: ‘ || round(v_Allocated_Bytes/1024/1024));
END;
/