OraFAQ Forum: Server Administration » Check invalid synonym with dblink

Home » RDBMS Server » Server Administration » Check invalid synonym with dblink

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

Check invalid synonym with dblink [message #58468]

Fri, 29 August 2003 07:45

VESSIER
Messages: 3
Registered: August 2003

Junior Member

Hello,

I'm looking for a script or method to check the validity of synonyms which point on an invalidate dblink object.

Thanks in advance.
Cordially.

Report message to a moderator

Do they show up as invalid in user_objects ? [message #58470 is a reply to message #58468]

Fri, 29 August 2003 10:32

aix_tom
Messages: 4
Registered: August 2003

Junior Member

then

select * from user_objects where object_type = 'VIEW' and status != 'VALID'

Other than that as system-user you have a view "synonyms" with a field "database".

And you have a view "all_db_links" with a field db_link

So you maybe could check :

select * from synonyms 
where database != 'LOCAL'
 and database not in (select db_link from all_db_links)

Tom

Report message to a moderator

Re: Do they show up as invalid in user_objects ? [message #58482 is a reply to message #58470]

Mon, 01 September 2003 04:16

VESSIER
Messages: 3
Registered: August 2003

Junior Member

In fact, i want to check the validity of objects on the dblink base.
Cordially.

Report message to a moderator

Previous Topic:	rbs segments
Next Topic:	Oracle/Solaris or Oracle/Linux

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:22:50 CDT 2024