Home » RDBMS Server » Networking and Gateways » dropping database links and materialized views (oracle10g, Linux AS4)
dropping database links and materialized views [message #362119] Mon, 01 December 2008 01:40 Go to next message
suresh.wst
Messages: 53
Registered: June 2008
Location: Hyderabad
Member
Hi,

Can a SYS user access database links and materialized views created by a normal user(scott). As a SYS user can we modify a DB link or materialized view created by normal user (scott).

Thanks & Regards
suresh.wst

Report message to a moderator

Re: dropping database links and materialized views [message #362122 is a reply to message #362119] Mon, 01 December 2008 01:44 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Why don't you just try it?
MVIEW: Yes
DBLINK: No.
SCOTT> create database link dblink connect to scott identified by tiger using 'mik

Database link created.

SCOTT> @sys
Connected.
SYS> drop database link scott.dblink;
drop database link scott.dblink
                   *
ERROR at line 1:
ORA-02024: database link not found

Regards
Michel

Report message to a moderator

Previous Topic: low level communication protocol
Next Topic: How can we change the Oracle Port
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 23 23:07:27 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.