Mega Code Archive
Categories
/
Oracle PLSQL
/
User Previliege
Create synonyms for dropped tables
SQL> SQL> SQL> SELECT 'CREATE PUBLIC SYNONYM ' || table_name 2 || ' for ' || user || '.' || table_name || ';' 3 FROM DBA_TABLES 4 WHERE dropped = 'NO'; no rows selected SQL>