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
    );