Refrescar un Snapshot MANUALMENTE

The 'REFRESH' stored procedure of the DBMS_SNAPSHOT package can be used
to manually refresh a snapshot. The syntax is:

EXECUTE dbms_snapshot.refresh (' [ schema.] name ' [, 'refresh_option'])

For example, to do a FAST refresh of the EMP snapshot:

EXECUTE dbms_snapshot.refresh ('emp', ' f ' ) ;

Refresh Options: 'F' or 'f' = FAST refresh
'C' or 'c' = COMPLETE refresh
'?' = DEFAULT refresh option