invalid synoyms
Hi,
I have about 200 invalid syonyms in schema. After checking a few of them, I realized that they are all valid. To mark them as valid I only must query them....
but I don't want to query 200 synonyms... maybe the next time there are over 1000.
I know, that this isn't a real problem, cause if a user want to use one of the invalid synonyms it will get valid... But I like a clean database ;-) and don't want any results after using:
COLUMN object_name FORMAT A30
SELECT owner,
object_type,
object_name,
status
FROM dba_objects
WHERE status = 'INVALID'
ORDER BY owner, object_type, object_name;
So is there an opportunity to "compile" synonyms? Thx for help.