Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> how to: list of synonyms (Oracle)?

how to: list of synonyms (Oracle)?

From: Marc <mphaan_at_hotmail.com>
Date: Thu, 27 Jan 2000 08:41:03 GMT
Message-ID: <zwTj4.265$kJ6.783@198.235.216.4> 





Hi folks,



I've got a corrupt synonym on my database. Problem is, I got a whole lot of
synonyms and I dont know which one is corrupt. So I want to delete or drop
all synonyms that contain 500 in the name.



Question: How can I get a list of synynyms from e certain schema level?



Marc


Received on Thu Jan 27 2000 - 02:41:03 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US