Folks;

I am trying to create a snapshot on 8.1.7.

However, after creating the snapshot, in the user_snapshot view, the table_name and the name appears the same.

Normally, once the snapshots are created successfully, SNAP$_ is prefixed to the table name in the table_name col. However that does not happen.

This is preventing me from granting select privs on the snapshot to another user.

Has anyone experienced this ? Any ideas why SNAP$_ is missing ? Any causes for this ... ?

Thanks in advance.