Oracle 12c sys.snap$ view does not exist -


i trying run redgate schema compare tool, , getting following errors:

select s.sowner owner, s.vname mview_name, decode(bitand(s.flag, 262144), 262144, 'y', 'n') reduced_precisions  sys.snap$ s  (s.sowner = 'obsolescence_data_store' ); 10:25:26.511|error  |object model        |7  |failed execute reader devart.data.oracle.oracleexception (0x80004005): ora-00942: table or view not exist @ devart.data.oracle.a7.b(int32 a_0) @ devart.data.oracle.a9.a(int32 a_0, bw a_1) @ devart.data.oracle.oraclecommand.internalexecute(commandbehavior behavior, idisposable disposable, int32 startrecord, int32 maxrecords, boolean nonquery) @ devart.common.dbcommandbase.executedbdatareader(commandbehavior behavior, boolean nonquery) @ devart.common.dbcommandbase.executedbdatareader(commandbehavior behavior) @ devart.data.oracle.oraclecommand.executereader() @ redgate.oracle.common.objectmodel.databasereader.executereader(string script) 

i tried query view directly sql developer, no luck. i'm assuming isn't correct, have no idea how fix it. appreciated.

i know question asked sometime back. others benifit respond.

as per knowledge these type of views can accessed sys user default. since user doesn't have dba , if aware of how logon "sys sysdba" should able access snap$.

the alternate method ask dba grant

grant select on sys.snap$ *[user logged in]* 

Comments