Home » RDBMS Server » Performance Tuning » the outline error why
the outline error why [message #189544] Fri, 25 August 2006 01:25 Go to next message
lazycat
Messages: 57
Registered: November 2005
Member
when i want to use the outline

i found some err
when
SQL> exec dbms_outln_edit.CREATE_EDIT_TABLES;

PL/SQL procedure successfully completed.

SQL> CREATE PRIVATE OUTLINE p_ol1 FROM ol1;
CREATE PRIVATE OUTLINE p_ol1 FROM ol1
*
ERROR at line 1:
ORA-18011: the outline specified in the FROM clause does not exist

who can tell me
what's wrong
Re: the outline error why [message #189576 is a reply to message #189544] Fri, 25 August 2006 02:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Seems your syntax is wrong.
  1*  CREATE PRIVATE OUTLINE t_emp on select * from emp
scott@9i > /

Outline created.
Re: the outline error why [message #189579 is a reply to message #189576] Fri, 25 August 2006 03:00 Go to previous messageGo to next message
lazycat
Messages: 57
Registered: November 2005
Member
Connect to a schema from which the outlined statement can be executed, and ensure that the CREATE ANY OUTLINE and SELECT privileges have been granted.
Create outline editing tables locally with the DBMS_OUTLN_EDIT.CREATE_EDIT_TABLES procedure.
Clone the outline being edited to the private area using the following:
CREATE PRIVATE OUTLINE p_ol1 FROM ol1;


Edit the outline, either with the Outline Editor in Enterprise Manager or manually by querying the local OL$HINTS tables and performing DML against the appropriate hint tuples. DBMS_OUTLN_EDIT.CHANGE_JOIN_POS is available for changing join order.
If manually editing the outline, then resynchronize the stored outline definition using the following so-called identity statement:
CREATE PRIVATE OUTLINE p_ol1 FROM PRIVATE p_ol1;


You can also use DBMS_OUTLN_EDIT.REFRESH_PRIVATE_OUTLINE or ALTER SYSTEM FLUSH SHARED_POOL to accomplish this.
Test the edits. Set USE_PRIVATE_OUTLINES=TRUE, and issue the outline statement or run EXPLAIN PLAN on the statement.
If you want to preserve these edits for public use, then publicize the edits with the following statement.
CREATE OR REPLACE OUTLINE ol1 FROM PRIVATE p_ol1;


Disable private outline usage by setting the following:
USE_PRIVATE_OUTLINES=FALSE

Re: the outline error why [message #189585 is a reply to message #189579] Fri, 25 August 2006 03:09 Go to previous message
lazycat
Messages: 57
Registered: November 2005
Member
ok i know it
thank you
Previous Topic: Oracle 9.0.2.7 enterprise problem
Next Topic: Analyze Command
Goto Forum:
  


Current Time: Thu Dec 08 18:10:13 CST 2016

Total time taken to generate the page: 0.06548 seconds