Session 01

View All Public Scripts Login to Run Script

Script Name Session 01
Visibility Unlisted - anyone with the share link can access
Description a test care for Ask TOM
Area Oracle 19c
Contributor pitest1
Created Tuesday February 28, 2023

Statement 1

declare 
  -- Local variables here 
  i integer; 
begin 
  dbms_mview.refresh('scott.nonExistentViewHere'); 
 
end;

ORA-20000: ORA-01031: insufficient privileges ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3020
ORA-06512: at "SYS.DBMS_IREFRESH", line 186
ORA-06512: at "SYS.DBMS_ISNAPSHOT", line 189
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 2852
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3263
ORA-06512: at "SYS.DBMS_SNAPSHOT_KKXRCA", line 3295
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 16
ORA-06512: at line 5
ORA-06512: at "SYS.DBMS_SQL", line 1721

More Details: https://docs.oracle.com/error-help/db/ora-20000

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database