stored outlines ...

From: Oradba Linux <techiey2k3_at_comcast.net>
Date: Thu, 6 Jan 2005 21:05:59 -0500
Message-ID: <yo2dnW6EuP7EckDcRVn-sA@comcast.com>

I am really confused about what is happening here. Why an outline is not created when i did an alter session. I am REDHAT LINUX ES3.0 and oracle 9204.

SQL> connect system/XXXXX
Connected.
SQL> grant create any outline to hr;

Grant succeeded.

SQL> connect hr/XXXXXXX
Connected.
SQL> alter session set create_stored_outlines=VIEWS   2 /

Session altered.

SQL> select
employee_id,job_id,manager_id,location_id,country_id,first_name,last_name   2 from emp_details_view where salary > 10000   3 /

<<< Deleted the rows >>>>
15 rows selected.

SQL> alter session set create_stored_outlines=false;

Session altered.

SQL> select sql_text from user_outlines;

no rows selected

SQL> show user
USER is "HR"
SQL> create or replace outline oln_emp_detail_view   2 for category views
  3 on
  4 select
employee_id,job_id,manager_id,location_id,country_id,first_name,last_name   5 from emp_details_view where salary > 10000   6 /

Outline created.

SQL> select sql_text from user_outlines;

SQL_TEXT

---

---

select
employee_id,job_id,manager_id,location_id,country_id,first_name,last_name

SQL> set long 5000
SQL> select * from user_outlines;

NAME                           CATEGORY                       USED


------------------------------ ------------------------------ ---------

TIMESTAMP VERSION
--------- ----------------------------------------------------------------
SQL_TEXT

---

---

SIGNATURE

---

OLN_EMP_DETAIL_VIEW            VIEWS                          UNUSED

06-JAN-05 9.2.0.4.0
select
employee_id,job_id,manager_id,location_id,country_id,first_name,last_name

from emp_details_view where salary > 10000

NAME                           CATEGORY                       USED


------------------------------ ------------------------------ ---------

TIMESTAMP VERSION
--------- ----------------------------------------------------------------
SQL_TEXT

---

---

SIGNATURE

---

0D5E9A2A0385988339AEFFF6B2871D2B Received on Thu Jan 06 2005 - 20:05:59 CST