HSWW_REPORT@atgdb1> @/home/oracle/bin/report_syn_all.sql; HSWW_REPORT@atgdb1> set hea off HSWW_REPORT@atgdb1> set line 120 HSWW_REPORT@atgdb1> set timing on HSWW_REPORT@atgdb1> alter session set recyclebin=OFF; Session altered. Elapsed: 00:00:00.01 HSWW_REPORT@atgdb1> create table delta11 as select * from PRODUCT_PRICE_V minus select * from PRODUCT_PRICE; Table created. Elapsed: 00:00:00.38 HSWW_REPORT@atgdb1> create table delta22 as select * from PRODUCT_PRICE minus select * from PRODUCT_PRICE_v; Table created. Elapsed: 00:00:00.42 HSWW_REPORT@atgdb1> delete from PRODUCT_PRICE where (sku_id) in (select sku_id from delta22); 0 rows deleted. Elapsed: 00:00:00.02 HSWW_REPORT@atgdb1> insert into PRODUCT_PRICE select * from delta11; 14535 rows created. Elapsed: 00:00:00.16 HSWW_REPORT@atgdb1> commit; Commit complete. Elapsed: 00:00:00.00 HSWW_REPORT@atgdb1> drop table delta22; Table dropped. Elapsed: 00:00:00.16 HSWW_REPORT@atgdb1> drop table delta11; Table dropped. Elapsed: 00:00:00.03 HSWW_REPORT@atgdb1> HSWW_REPORT@atgdb1> create table delta11 as select * from PRODUCT_IMAGE_V minus select * from PRODUCT_IMAGE; Table created. Elapsed: 00:00:01.70 HSWW_REPORT@atgdb1> create table delta22 as select * from PRODUCT_IMAGE minus select * from PRODUCT_IMAGE_v; Table created. Elapsed: 00:00:00.39 HSWW_REPORT@atgdb1> delete from PRODUCT_IMAGE where (product_id,path,name) in (select product_id,path,name from delta22); 0 rows deleted. Elapsed: 00:00:00.01 HSWW_REPORT@atgdb1> insert into PRODUCT_IMAGE select * from delta11; 33672 rows created. Elapsed: 00:00:00.15 HSWW_REPORT@atgdb1> commit; Commit complete. Elapsed: 00:00:00.01 HSWW_REPORT@atgdb1> drop table delta22; Table dropped. Elapsed: 00:00:00.05 HSWW_REPORT@atgdb1> drop table delta11; Table dropped. Elapsed: 00:00:00.04 HSWW_REPORT@atgdb1> HSWW_REPORT@atgdb1> create table delta11 as select * from PRODUCT_IMAGE_V_all minus select * from PRODUCT_IMAGE_all; Table created. Elapsed: 00:00:00.80 HSWW_REPORT@atgdb1> create table delta22 as select * from PRODUCT_IMAGE_all minus select * from PRODUCT_IMAGE_v_all; Table created. Elapsed: 00:00:00.39 HSWW_REPORT@atgdb1> delete from PRODUCT_IMAGE_all where (product_id,path,name) in (select product_id,path,name from delta22); 0 rows deleted. Elapsed: 00:00:00.00 HSWW_REPORT@atgdb1> insert into PRODUCT_IMAGE_all select * from delta11; 65947 rows created. Elapsed: 00:00:00.33 HSWW_REPORT@atgdb1> commit; Commit complete. Elapsed: 00:00:00.01 HSWW_REPORT@atgdb1> drop table delta22; Table dropped. Elapsed: 00:00:00.36 HSWW_REPORT@atgdb1> drop table delta11; Table dropped. Elapsed: 00:00:00.07 HSWW_REPORT@atgdb1> HSWW_REPORT@atgdb1> HSWW_REPORT@atgdb1> create table delta11 as select distinct PRODUCT_ID,name,max(asset_VERSION) over (partition by PRODUCT_ID) max_asset_version from PRODUCT_IMAGE_BCC_V minus select PRODUCT_ID,name,max_asset_version from PRODUCT_IMAGE_bcc; Table created. Elapsed: 00:00:06.75 HSWW_REPORT@atgdb1> create table delta22 as select PRODUCT_ID,name,max_asset_version from PRODUCT_IMAGE_bcc minus select distinct PRODUCT_ID,name,max(asset_VERSION) over (partition by PRODUCT_ID) max_asset_version from PRODUCT_IMAGE_bcc_v; Table created. Elapsed: 00:00:04.16 HSWW_REPORT@atgdb1> delete from PRODUCT_IMAGE_bcc where (PRODUCT_ID,name) in (select PRODUCT_ID,name from delta22); 0 rows deleted. Elapsed: 00:00:00.01 HSWW_REPORT@atgdb1> insert into PRODUCT_IMAGE_bcc select * from delta11; 68657 rows created. Elapsed: 00:00:00.22 HSWW_REPORT@atgdb1> commit; Commit complete. Elapsed: 00:00:00.00 HSWW_REPORT@atgdb1> drop table delta22; Table dropped. Elapsed: 00:00:00.04 HSWW_REPORT@atgdb1> drop table delta11; Table dropped. Elapsed: 00:00:00.04 HSWW_REPORT@atgdb1> HSWW_REPORT@atgdb1> HSWW_REPORT@atgdb1> create table delta11 as select distinct PRODUCT_ID,path,name,max(asset_VERSION) over (partition by PRODUCT_ID) max_asset_version from PRODUCT_IMAGE_BCC_V_all minus select PRODUCT_ID,path,name,max_asset_version from PRODUCT_IMAGE_bcc_all; Table created. Elapsed: 00:00:10.87 HSWW_REPORT@atgdb1> create table delta22 as select PRODUCT_ID,path,name,max_asset_version from PRODUCT_IMAGE_bcc_all minus select distinct PRODUCT_ID,path,name,max(asset_VERSION) over (partition by PRODUCT_ID) max_asset_version from PRODUCT_IMAGE_bcc_v_all; Table created. Elapsed: 00:00:09.72 HSWW_REPORT@atgdb1> delete from PRODUCT_IMAGE_bcc_all where (PRODUCT_ID,path,name) in (select PRODUCT_ID,path,name from delta22); 0 rows deleted. Elapsed: 00:00:00.02 HSWW_REPORT@atgdb1> insert into PRODUCT_IMAGE_bcc_all select * from delta11; 89056 rows created. Elapsed: 00:00:00.98 HSWW_REPORT@atgdb1> commit; Commit complete. Elapsed: 00:00:00.01 HSWW_REPORT@atgdb1> drop table delta22; Table dropped. Elapsed: 00:00:00.05 HSWW_REPORT@atgdb1> drop table delta11; Table dropped. Elapsed: 00:00:00.03 HSWW_REPORT@atgdb1> HSWW_REPORT@atgdb1> drop table product_image_bcc_n; Table dropped. Elapsed: 00:00:00.14 HSWW_REPORT@atgdb1> create table product_image_bcc_n as select distinct p1.product_id, p1.name, p1.MAX_ASSET_VERSION from product_image_bcc p1, EPUB_FILE_ASSET p2 where p1.name=p2.FILENAME; create table product_image_bcc_n as select distinct p1.product_id, p1.name, p1.MAX_ASSET_VERSION from product_image_bcc p1, EPUB_FILE_ASSET p2 where p1.name=p2.FILENAME * ERROR at line 1: ORA-00942: table or view does not exist Elapsed: 00:00:00.01 HSWW_REPORT@atgdb1> HSWW_REPORT@atgdb1> -- drop table product_image_bcc_all_n; HSWW_REPORT@atgdb1> -- create table product_image_bcc_all_n as select distinct p1.product_id, p1.name, p1.MAX_ASSET_VERSION from product_image_bcc_all p1, EPUB_FILE_ASSET@PRD_BCC_pub p2 where p1.name=p2.FILENAME; HSWW_REPORT@atgdb1> HSWW_REPORT@atgdb1> -- grant select on product_image_bcc_all_n to hsww_read; HSWW_REPORT@atgdb1> grant select on product_image_bcc_n to hsww_read; grant select on product_image_bcc_n to hsww_read * ERROR at line 1: ORA-00942: table or view does not exist Elapsed: 00:00:00.01 HSWW_REPORT@atgdb1> HSWW_REPORT@atgdb1> SPOOL OFF;