How much table space size is needed to run 'CREATE SNAPSHOT' where log segment size for table is 45
I am trying to run below commnad.
CREATE SNAPSHOT REGISTRY.IMAGE TABLESPACE CONFIGD STORAGE(INITIAL 131072 NEXT 131072) lob(IMAGE,IMAGE_FILTER,LICENSE_INFO) STORE AS (TABLESPACE CONFIGD STORAGE (INITIAL 128k NEXT 8192k PCTINCREASE 0)) REFRESH FAST WITH PRIMARY KEY AS SELECT * FROM REGISTRY.IMAGE@ORCL;
execute dbms_refresh.add('"REGISTRY"."REGISTRY_RG"', '"REGISTRY"."IMAGE"');
It is giving below error:
ERROR at line 1:
ORA-12008: error in materialized view refresh path
ORA-24801: illegal parameter value in OCI lob function
ORA-02063: preceding line from E2ECONSD
ORA-01691: unable to extend lob segment REGISTRY.SYS_LOB0000592078C00008$$ by
128 in tablespace CONFIGD
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821
0