使用Oracle9i数据库的九大注意事项

核心提示： drop public synonym OWA_CUSTOM; drop public synonym OWA_GLOBAL; drop public synonym OWA; drop public synonym HTF;

　　drop public synonym OWA_CUSTOM;
　　 drop public synonym OWA_GLOBAL;
　　 drop public synonym OWA;
　　 drop public synonym HTF;
　　 drop public synonym HTP;
　　 drop public synonym OWA_COOKIE;
　　 drop public synonym OWA_IMAGE;
　　 drop public synonym OWA_OPT_LOCK;
　　 drop public synonym OWA_PATTERN;
　　 drop public synonym OWA_SEC;
　　 drop public synonym OWA_TEXT;
　　 drop public synonym OWA_UTIL;
　　 drop public synonym OWA_INIT;
　　 drop public synonym OWA_CACHE;
　　 drop public synonym WPG_DOCLOAD;

３．连接到OWA包的安装模式oas_public，确保该用户具有CREATE PUBLIC SYNONYM权限，如果没有，则须手动为此用户授此权限。

4．运行下列命令。这将重新建立OWA公共同义词使其参照到Oracle Application Server 的OWA包。

　　create public synonym OWA_CUSTOM for OWA_CUSTOM;
　　 create public synonym OWA_GLOBAL for OWA_CUSTOM;
　　 create public synonym OWA for OWA;
　　 create public synonym HTF for HTF;
　　 create public synonym HTP for HTP;
　　 create public synonym OWA_COOKIE for OWA_COOKIE;
　　 create public synonym OWA_IMAGE for OWA_IMAGE;
　　 create public synonym OWA_OPT_LOCK for OWA_OPT_LOCK;
　　 create public synonym OWA_PATTERN for OWA_PATTERN;
　　 create public synonym OWA_SEC for OWA_SEC;
　　 create public synonym OWA_TEXT for OWA_TEXT;
　　 create public synonym OWA_UTIL for OWA_UTIL;
　　 create public synonym OWA_INIT for OWA_CUSTOM;
　　 create public synonym OWA_CACHE for OWA_CACHE;
　　 create public synonym WPG_DOCLOAD for WPG_DOCLOAD;