How to monitor progress of table creation using CTAS method?
in gv$session_longops for corresponding SID - It shows INDEX SCAN Completed and percent is 100%.
CREATE TABLE A.TEMP_TABLE
TABLESPACE DATA
NOLOGGING
PARALLEL 4
AS SELECT * FROM B.ACTIV_REC@DBLINK as of scn 10902280771618
WHERE STATUS IN ('PENDING');
B.ACTIV_REC table has 10 million records and TEMP_TABLE will pull 1 million records.
Thanks,
Veera