Hi all,
Got error when trying to refresh materialized view.
exec dbms_refresh.refresh('scheme.SNAP_1');
Error report -
ORA-01882: timezone region not found
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2254
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2460
ORA-06512: at "SYS.DBMS_IREFRESH", line 683
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 1
01882. 00000 - "timezone region not found"
*Cause: The specified region name was not found.
*Action: Contact Oracle Support Services.
What can cause this error and how to solve?