清茶居士

摘要： 视图名描述ALL_CATALOGAll tables, views, synonyms, sequences accessible to the userALL_COL_COMMENTSComments on columns of accessible tables and viewsALL_COL_GRANTS_MADEGrants on columns for which the user is owner or grantorALL_COL_GRANTS_RECDGrants on columns for which the user or PUBLIC is the granteeAL 阅读全文

摘要： 要把某几个的package源代码备份导出，方法如下：set long 10240000spool c:\package.sqlselect text from all_source where ....spool off1.找出需要的包名SELECT * FROM all_objects t WHERE t.object_type = 'PACKAGE' AND owner = 'APPS' AND trunc(t.last_ddl_time) > to_date('2011-3-11', 'YYYY-MM-DD') AND 阅读全文