OraFAQ Forum: Networking and Gateways » dropping database links and materialized views

Home » RDBMS Server » Networking and Gateways » dropping database links and materialized views (oracle10g, Linux AS4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dropping database links and materialized views [message #362119]

Mon, 01 December 2008 01:40

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

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why don't you just try it?
MVIEW: Yes
DBLINK: No.

Code: [Select all] [Show/ hide]

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 05 11:59:50 CDT 2025