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

Try with "ADMINISTER DATABASE TRIGGER" On 2003.08.13 04:29, Jack van Zanen wrote:
>
>
> 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).
>

-- 
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mgogala_at_adelphia.net

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