Database Administration (MOSC)

MOSC Banner

access data across databases after upgrade to 11g

edited Jan 16, 2011 8:08AM in Database Administration (MOSC) 8 commentsAnswered ✓
  Hi, after I upgraded to 11G, I can no longer access sys or v$ tables across databases using sys or system IDs.

The database links are connecting through the system ID.

e.g.
create public database link prsp
 connect to system identified by password using 'prsp';


However when I issue a select to the v$tables it doesn't work.

select name from v$database@prsp
                            *
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-02063: preceding line from PRSP

BUT, if i issue :
select * from global_name@prsp;

GLOBAL_NAME
--------------------------------------------------------------------------------
PRSP.PNC.EDU

This does work successfully.  What additional privs do I have to give to sys or system for this to work as it did in all previous Oracle versions?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center