| |
 |
|
ss
Oracle Tips by Burleson |
Chapter 7 Oracle Storage and Object
Internal Scripting
rem
rem NAME: outline_hint.sql
rem FUNCTION: Generate a lit of all outlines in the
rem database for a specific user and outline or all users
rem and outlines
rem HISTORY: MRA 5/13/98 Created
rem
COLUMN owner FORMAT a8 HEADING 'Owner'
COLUMN name FORMAT a13 HEADING 'Outline|Name'
COLUMN category FORMAT a10 HEADING 'Category|Name'
COLUMN node FORMAT 9999 HEADING 'Node'
COLUMN join_pos FORMAT 9999 HEADING 'Join|Pos'
COLUMN hint FORMAT A27 HEADING 'Hint Text' WORD_WRAPPED
BREAK ON owner ON category ON name
SET PAGES 58 LINES 78 FEEDBACK OFF VERIFY OFF
ttitle 'Database OUTLINE Report'
SPOOL outline_hint.lis
SELECT
a.owner,
a.name,
a.category, b.node,
b.join_pos, b.hint
FROM
Dba_outlines a, dba_outline_hints b
SEE CODE DEPOT FOR FULL SCRIPT
ORDER BY
owner,category,name,b.node;
SPOOL OFF
CLEAR BREAKS
TTITLE OFF
SET FEEDBACK ON VERIFY ON
Here is a sample listing.
Outline Category Join
Owner
Name Name Node Pos Hint Text
--------
------------- ----------- ----- ---- ---- --------------------
TELE_DBA
TEST_OUTLINE2 TEST 1 0 NO_EXPAND
1 0 ORDERED
1 1
NO_ACCESS(DBA_DATA_FILES)
1 0 NOREWRITE
1 0 NO_FACT(DBA_DATA_FILES)
1 0 NOREWRITE
2 0
NO_EXPAND
2 0
ORDERED
Mike has
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link:
|
