重建同義詞
SELECT 'drop synonym ' || rtrim(OBJECT_NAME) || ';',
'create synonym ' || rtrim(OBJECT_NAME) || ' FOR ' || USER || '.' || rtrim(OBJECT_NAME) || ';'
FROM user_objects
WHERE object_type IN
('TABLE', 'PACKAGE', 'PROCEDURE', 'FUNCTION', 'VIEW', 'SEQUENCE')
ORDER BY 2;
