Re: How to take sql*loader trace/ AFTER LOGON SCHEMA TRIGGER

Does the user whom you created the trigger have "alter session" privilege?

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, August 12, 2003 4:39 PM

> As system (8.1.7.3):
>
> create or replace trigger <TRIGGER_NAME>
> after logon on <SCHEMA>.schema
> begin
> Execute immediate 'alter session set events=''10046 trace name context
> forever, level 12''';
> end;
>
>
> When I logon after creating this trigger as the user <SCHEMA> I get the
> error message insufficient privileges.
> If I grant DBA it seems to work but that is a bit much for privileges.
>
> Which privileges are neccesary to run this??
>
> Just alter session won't work.
>
>
> Jack
>
>
> -----Original Message-----
> Sent: Monday, August 11, 2003 4:59 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Create or replace database trigger turn_tracing_on after logon on
> schema.scott Begin Execute immediate 'alter session set events=''10046
trace
> name context forever, level 8'''; End; /
>
> That should give you more then enough info to trace, especially on 9i.
>
> --
> Mladen Gogala
> Oracle DBA
>
>
>
> -----Original Message-----
> Senthil Kumar
> Sent: Monday, August 11, 2003 10:39 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi All,
>
> I'm loading a set of data into one of my schema. And wanted to take the
> trace files also.
>
> I tried the follwoing.
>
> 1. Identified the sid,serila# for the sql*loader session.
> 2. used the follwoing,
> exec sys.dbms_system.set_sql_trace_in_session(19,11250,TRUE);
>
> but this is not generation any trace files. But if I trun my system to
> sql_trace=TRUE, I'm able to collect the trace details. I don't want to do
> this.
>
> I want to take the trace only for the sql*loader session. How do i do
that.
>
> TIA,
> Senthil.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Senthil Kumar
> INET: senthilkumard_at_summitworks.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also send the HELP
> command for other information (like subscribing).
>
>
> --------------------------------------------------------
> Note:
> This message is for the named person's use only. It may
> contain confidential, proprietary or legally privileged
> information. No confidentiality or privilege is waived
> or lost by any mistransmission. If you receive this
> message in error, please immediately delete it and all
> copies of it from your system, destroy any hard copies
> of it and notify the sender. You must not, directly or
> indirectly, use, disclose, distribute, print, or copy
> any part of this message if you are not the intended
> recipient. Wang Trading LLC and any of its subsidiaries
> each reserve the right to monitor all e-mail
> communications through its networks.
>
> Any views expressed in this message are those of the
> individual sender, except where the message states
> otherwise and the sender is authorized to state them
> to be the views of any such entity.
> ---------------------------------------------------------
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mladen_at_wangtrading.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also send the HELP
> command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jack van Zanen
> INET: JACK_at_QUANTSYSTEMS.NL
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).