[sql] 
1¡¢ÏȲéÓÐûÓÐÑ­»·µÄͬÒå´Ê£º  
    select * from dba_synonyms where   
    table_owner='test' and synonym_name  
    <>table_name;ûÓмǼ  
  
    2¡¢ÔÙ²éͬÒå´ÊûÓжÔÏóµÄÊý¾Ý¿â¶ÔÏó£º  
    select * from dba_synonyms where   
    table_owner='test'   
    and sysnonym_name in(select a.synonym_name from dba_synonyms a  
    where a.table_owner='test'  
    minus  
    select object_name from user_objects  
    )  
  
    3¡¢°Ñ²éѯ³öÀ´µÄ½á¹û½øÐвéѯ±í  
    select * from DRILL_PRESON  
    Èç¹û¸ÃͬÒå´ÊûÓжÔÓ¦µÄ¶ÔÏ󣬾ͻᱨora_01775µÄ´íÎó  
  
    4¡¢É¾³ýÕâ¸öͬÒå´Ê£º  
    drop public synonym DRILL_PRESON