Skip to Main Content

error when trying to refresh materialized view

2792584Nov 18 2014 — edited Nov 18 2014

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?

Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Dec 16 2014
Added on Nov 18 2014