access data across databases after upgrade to 11g
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?
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?
0