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
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: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: low level communication protocol
Next Topic: How can we change the Oracle Port
Goto Forum:
  


Current Time: Fri Mar 29 00:28:29 CDT 2024