"Oradba Linux" <techiey2k3_at_comcast.net> wrote in message
news:yo2dnWmEuP7EckDcRVn-sA_at_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
>
>
>
I tried again and it works !! I dont know what i messed up last time.
I did not have cursor_sharing=force just in case any of you were thinking of
that.
Received on Thu Jan 06 2005 - 20:44:52 CST
