Using Supplied Packages to Manage Stored Outlines
The DBMS_OUTLN and DBMS_OUTLN_EDIT package provides procedures used for
managing stored outlines and their outline categories.
Users need the EXECUTE_CATALOG_ROLE role to execute DBMS_OUTLN, but public
has execute privileges on DBMS_OUTLN_EDIT. The DBMS_OUTLN_EDIT package is an
invoker's rights package.
Some of the useful DBMS_OUTLN and DBMS_OUTLN_EDIT procedures are:
■ CLEAR_USED - Clears specified outline
■ DROP_BY_CAT - Drops outlines that belong to a specified category
■ UPDATE_BY_CAT - Changes the category of outlines in one specified category to
a new specified category
■ EXACT_TEXT_SIGNATURES - Computes an outline signature according to an
exact text matching scheme
■ GENERATE_SIGNATURE - Generates a signature for the specified SQL text[@more@]
managing stored outlines and their outline categories.
Users need the EXECUTE_CATALOG_ROLE role to execute DBMS_OUTLN, but public
has execute privileges on DBMS_OUTLN_EDIT. The DBMS_OUTLN_EDIT package is an
invoker's rights package.
Some of the useful DBMS_OUTLN and DBMS_OUTLN_EDIT procedures are:
■ CLEAR_USED - Clears specified outline
■ DROP_BY_CAT - Drops outlines that belong to a specified category
■ UPDATE_BY_CAT - Changes the category of outlines in one specified category to
a new specified category
■ EXACT_TEXT_SIGNATURES - Computes an outline signature according to an
exact text matching scheme
■ GENERATE_SIGNATURE - Generates a signature for the specified SQL text[@more@]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/10599713/viewspace-1007355/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- stored outlines遷移成SQL執行計劃基線SQL
- 利用 trigger 修改 資料庫啟動USE_STORED_OUTLINES資料庫
- Send Email with Attachments from PL/SQL using Java Stored ProceduresAISQLJava
- Using srvctl to Manage your 10g RAC DatabaseDatabase
- How Views are Stored (175)View
- The password supplied with the username Domain\UserName was not correct. Verify that it was entered ...AI
- How to rename an Oracle stored procedureOracle
- Oracle stored procedure to send emailOracleAI
- manage-docs-versions
- python modules and packagesPythonPackage
- Linux Packages SearchLinuxPackage
- Types of SAP Support PackagesPackage
- oracle實驗記錄 （使用outlines）Oracle
- oracle實驗記錄 （管理outlines）Oracle
- execute shell script from stored procedure
- How Indexes Are Stored (206)Index
- AFX_MANAGE_STATE(AfxGetStaticModuleState())
- manage logical standby databaseDatabase
- Manage RSS feeds with the Rome APIAPI
- oracle實驗記錄 （管理outlines） 轉Oracle
- oracle實驗記錄 （移動outlines）Oracle
- 每日一個 Golang PackagesGolangPackage
- nuget packages batch installPackageBAT
- Session State and Referenced Packages (246)SessionPackage
- iOS解決CUICatalog: Invalid asset name supplied問題iOSUI
- 【PLAN STABILITY】 STORED-OUTLINE
- stored procedure 收集session wait 資訊SessionAI
- How to use sql result stored on shell variable?SQL
- Result Sets from Stored Procedures In Oracle (轉)Oracle
- PL/SQL Packages DBMS_STATSSQLPackage
- stored procedure 收集session wait 資訊(轉)SessionAI
- npm publish gives “unscoped packages cannot be private”NPMPackage
- revoke EXECUTE privileges on powerful packages from PUBLICPackage
- Software Packages in `experimental' - 安裝方法(轉)Package
- Entity Framework Tutorial Basics（29）：Stored Procedure in Entity FrameworkFramework
- InnoDB: Error: space id and page n:o stored in the page?Error
- oracle儲存提綱（stored outline）Oracle
- OWI --用 stored procedure 收集session wait 資訊SessionAI