Welcome to Oracle PL SQL Performance Tuning and Optimization. At Oracle PL SQL Performance Tuning and Optimization talk about Administration of Stored Outlines

Friday, July 27

Administration of Stored Outlines

Administration of Stored Outlines -

There are a few more topics related to administering stored outlines. To drop a stored outline, use the DROP OUTLINE command as follows:

DROP OUTLINE employee_application;
The category name is supplied. The outline will be removed from the OL$ and OL$HINTS table. Use the export utility to create a backup of your stored outline, as described above, before dropping it.

The ALTER OUTLINE command can be used to rename a category.

ALTER OUTLINE employee_application CHANGE CATEGORY TO emp_outline;
Note:  Doing the above operation will cause your application to not be able to find the stored outline it is looking for unless you change the USE_STORED_OUTLINE parameter value as well.

0 comments:

Post a Comment

Copyright © 2013 Oracle PL SQL Performance Tuning and Optimization | Oracle PL SQL Performance Tuning and Optimization