SQL>SQL>SQL> SELECT 'CREATE PUBLIC SYNONYM ' || table_name 2 || ' for ' || user || '.' || table_name || ';' 3 FROM DBA_TABLES 4 WHERE dropped = 'NO';no rows selectedSQL>