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
Post a Comment