• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Posted By

kamilch on 11/19/10

Tagged

Versions (?)

11/19/10 02:37am

 / Published in: PL/SQL

 

SELECT 'CREATE or REPLACE SYNONYM ' || :target_schema || '.' || object_name || ' for ' || :src_schema || '.' || object_name || ';' FROM (
SELECT table_name AS object_name FROM all_all_tables WHERE owner = :src_schema
UNION
SELECT sequence_name AS object_name FROM all_sequences WHERE sequence_owner = :src_schema
);

Report this snippet   Tweet