DBMS_OUTLN_EDIT

This package contains the functional interface to manage stored outlines.

The public role has execute privileges on DBMS_OUTLN_EDIT, which is defined with invoker's rights.

Procedures

The most relevant procedures are:

  • CREATE_EDIT_TABLES: creates outline editing tables in calling a user's schema; beginning from Oracle 10g, you will not need to use this procedure because the outline editing tables are part—as temporary tables—of the SYSTEM schema
  • REFRESH_PRIVATE_OUTLINE: refreshes the in-memory copy of the outline, synchronizing its data with the edits made to the outline hints
  • DROP_EDIT_TABLES: drops the outline editing tables from the calling user's schema

Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial