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

Yes I tried granting alter session first

-----Original Message-----
Sent: Tuesday, August 12, 2003 11:24 PM
To: Multiple recipients of list ORACLE-L

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).
-- 
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).