ORACLE数据库开发基础第十章其它(6)

select 'create public synonym ' || table_name || ' for ' || upper('&&username') || '.' || table_name || ';' fromall_tables

where owner = upper('&&username') ;

select 'drop public synonym ' || view_name || ';' from all_views where owner = upper('&&username') ;

select 'create public synonym ' || view_name || ' for ' || upper('&&username') || '.' || view_name || ';' fromall_views

where owner = upper('&&username') ;

select 'drop public synonym ' || SEQUENCE_NAME || ';' from ALL_SEQUENCES where SEQUENCE_OWNER = upper('&&username') ;

select 'create public synonym ' || SEQUENCE_NAME || ' for ' || upper('&&username') || '.' ||

SEQUENCE_NAME || ';'

from ALL_SEQUENCES where SEQUENCE_OWNER = upper('&&username') ; spool off

2. 运行时，只要输入用户名字即可，如： SQL> start c:\\syn.txt 输入希望的用户名: zhao

原值 1: select 'drop public synonym ' || table_name || ';' from all_tables where owner 新值 1: select 'drop public synonym ' || table_name || ';' from all_tables where owner drop public synonym ABC; . . . . . .

3. 编辑产生创建脚本的cre_syn.sql 文件，保留drop synonyms 和create public synonym 两

种语句，删除“原值 1: select”和“新值 1: select”.