Posted By

kamilch on 11/19/10


Tagged


Versions (?)

Generate SYNONYMS SQL


 / Published in: PL/SQL
 

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

Report this snippet  

You need to login to post a comment.