FAQ
Hi guys

I am trying to create the following trigger.

The user in question is logging in using siebel application and siebel does
not allow multiple SQL statements during login so we through this might
solve the problem. My problem now is though, the set rollback works but the
alter session statements does not seem to want to work.

The server needs to be in RBO since this is the only mode supported by
siebel.

Help appreciated.

create or replace trigger smload.logon after logon on database
begin

SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
Alter session enable parallel query;
Alter session set SORT_AREA_SIZE = 10485760;
Alter session set OPTIMIZER_MODE = choose;

end;
/

George

George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:george.leonard_at_za.didata.com
Web: http://www.didata.co.za


You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
or Injure Themselves as They See Fit!

This message contains information intended solely for the addressee,
which is confidential or private in nature and subject to legal privilege.
If you are not the intended recipient, you may not peruse, use,
disseminate, distribute or copy this message or any file attached to this
message. Any such unauthorised use is prohibited and may be unlawful. If
you have received this message in error, please notify the sender
immediately by e-mail, facsimile or telephone and thereafter delete the
original message from your machine.


Furthermore, the information contained in this message, and any
attachments thereto, is for information purposes only and may contain the
personal views and opinions of the author, which are not necessarily the
views and opinions of Dimension Data (South Africa) (Proprietary) Limited
or its subsidiaries and associated companies ("Dimension Data"). Dimension
Data therefore does not accept liability for any claims, loss or damages
of whatsoever nature, arising as a result of the reliance on such
information by anyone.


Whilst all reasonable steps are taken to ensure the accuracy and
integrity of information transmitted electronically and to preserve the
confidentiality thereof, Dimension Data accepts no liability or
responsibility whatsoever if information or data is, for whatsoever
reason, incorrect, corrupted or does not reach its intended destination.



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: George Leonard (ZA)
INET: George.Leonard_at_za.didata.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).

Search Discussions

  • Igor Neyman at Oct 2, 2002 at 3:43 pm
    "Alter session ..." is not DML, so I think you need to use dynamic SQL:

    create or replace trigger smload.logon after logon on database
    begin
    SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;

    EXECUTE IMMEDIATE "Alter session enable parallel query";
    EXECUTE IMMEDIATE "Alter session set SORT_AREA_SIZE = 10485760";
    EXECUTE IMMEDIATE "Alter session set OPTIMIZER_MODE = choose";

    end;
    /

    Igor Neyman, OCP DBA
    ineyman_at_perceptron.com

    Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Wednesday, October 02, 2002 11:23 AM
    Hi guys

    I am trying to create the following trigger.

    The user in question is logging in using siebel application and siebel does
    not allow multiple SQL statements during login so we through this might
    solve the problem. My problem now is though, the set rollback works but the
    alter session statements does not seem to want to work.

    The server needs to be in RBO since this is the only mode supported by
    siebel.

    Help appreciated.

    create or replace trigger smload.logon after logon on database
    begin
    SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
    Alter session enable parallel query;
    Alter session set SORT_AREA_SIZE = 10485760;
    Alter session set OPTIMIZER_MODE = choose;
    end;
    /

    George
    ________________________________________________
    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za

    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!



    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.


    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: George Leonard (ZA)
    INET: George.Leonard_at_za.didata.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.com
    --
    Author: Igor Neyman
    INET: ineyman_at_perceptron.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).
  • Paul.Parker_at_bmwna.com at Oct 2, 2002 at 3:50 pm
    use

    execute immediate 'alter session enable parallel query';

    Paul

    -----Original Message-----
    Sent: Wednesday, October 02, 2002 11:24 AM
    To: Multiple recipients of list ORACLE-L

    Hi guys

    I am trying to create the following trigger.

    The user in question is logging in using siebel application and siebel does
    not allow multiple SQL statements during login so we through this might
    solve the problem. My problem now is though, the set rollback works but the
    alter session statements does not seem to want to work.

    The server needs to be in RBO since this is the only mode supported by
    siebel.

    Help appreciated.

    create or replace trigger smload.logon after logon on database
    begin

    SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
    Alter session enable parallel query;
    Alter session set SORT_AREA_SIZE = 10485760;
    Alter session set OPTIMIZER_MODE = choose;

    end;
    /

    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!

    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.


    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.


    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.



    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: George Leonard (ZA)
    INET: George.Leonard_at_za.didata.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.com
    --
    Author:
    INET: Paul.Parker_at_bmwna.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).
  • JOE TESTA at Oct 2, 2002 at 3:53 pm
    George here is how we did ours"

    create or replace trigger olap1_logon_trigger
    after logon on olap1.schema
    begin
    execute immediate 'alter session set optimizer_mode = first_rows';
    end;
    /

    Customize it to your liking.

    Joe

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: JOE TESTA
    INET: JTESTA_at_longaberger.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).
  • Paquette stephane at Oct 2, 2002 at 4:13 pm
    Hi,

    Use dynamic SQL (execute imediate).

    Also, consider placing your code into a stored proc
    called by the trigger.

    "George Leonard (ZA)"
    a écrit : > Hi guys
    I am trying to create the following trigger.

    The user in question is logging in using siebel
    application and siebel does
    not allow multiple SQL statements during login so we
    through this might
    solve the problem. My problem now is though, the set
    rollback works but the
    alter session statements does not seem to want to
    work.

    The server needs to be in RBO since this is the only
    mode supported by
    siebel.

    Help appreciated.

    create or replace trigger smload.logon after logon
    on database
    begin
    SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
    Alter session enable parallel query;
    Alter session set SORT_AREA_SIZE = 10485760;
    Alter session set OPTIMIZER_MODE = choose;
    end;
    /

    George
    ________________________________________________
    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za

    You Have The Obligation to Inform One Honestly of
    the risk, And As a Person
    You Are Committed to Educate Yourself to the Total
    Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every
    Fool Has the Right to Kill
    or Injure Themselves as They See Fit!



    This message contains information intended solely
    for the addressee,
    which is confidential or private in nature and
    subject to legal privilege.
    If you are not the intended recipient, you may not
    peruse, use,
    disseminate, distribute or copy this message or any
    file attached to this
    message. Any such unauthorised use is prohibited and
    may be unlawful. If
    you have received this message in error, please
    notify the sender
    immediately by e-mail, facsimile or telephone and
    thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this
    message, and any
    attachments thereto, is for information purposes
    only and may contain the
    personal views and opinions of the author, which are
    not necessarily the
    views and opinions of Dimension Data (South Africa)
    (Proprietary) Limited
    or its subsidiaries and associated companies
    ("Dimension Data"). Dimension
    Data therefore does not accept liability for any
    claims, loss or damages
    of whatsoever nature, arising as a result of the
    reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the
    accuracy and
    integrity of information transmitted electronically
    and to preserve the
    confidentiality thereof, Dimension Data accepts no
    liability or
    responsibility whatsoever if information or data is,
    for whatsoever
    reason, incorrect, corrupted or does not reach its
    intended destination.


    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: George Leonard (ZA)
    INET: George.Leonard_at_za.didata.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).
    Stéphane Paquette
    DBA Oracle, consultant entrepôt de données
    Oracle DBA, datawarehouse consultant
    stephane_paquette_at_yahoo.com

    Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français !
    Yahoo! Mail : http://fr.mail.yahoo.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: =?iso-8859-1?q?paquette=20stephane?=
    INET: stephane_paquette_at_yahoo.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).
  • Dgoulet_at_vicr.com at Oct 2, 2002 at 4:13 pm
    George,

    The SET TRANSACTION command, according to the documentation, only lasts
    until the next commit/rollback. That being the case I would not expect it's
    duration to be very long. Also, I am not in favor of assigning a particular
    application/session to any specific rollback segment since it has little effect
    on overall database performance or capability. Sure it was applicable in older
    versions of Oracle where a rollback segment behaved like a table, but since 7.x
    where the optimal parameter came into use I prefer to set all rollback segments
    as small, but with the ability to expand as needed. It has eliminated my need
    for large rollback segments and almost eliminated the ORA-01555 errors.

    Dick Goulet

    ____________________Reply Separator____________________
    Author: "George Leonard (ZA)"
    Date: 10/2/2002 7:23 AM

    Hi guys

    I am trying to create the following trigger.

    The user in question is logging in using siebel application and siebel does
    not allow multiple SQL statements during login so we through this might
    solve the problem. My problem now is though, the set rollback works but the
    alter session statements does not seem to want to work.

    The server needs to be in RBO since this is the only mode supported by
    siebel.

    Help appreciated.

    create or replace trigger smload.logon after logon on database
    begin

    SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
    Alter session enable parallel query;
    Alter session set SORT_AREA_SIZE = 10485760;
    Alter session set OPTIMIZER_MODE = choose;

    end;
    /

    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!

    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.


    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.


    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.



    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: George Leonard (ZA)
    INET: George.Leonard_at_za.didata.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.com
    --
    Author:
    INET: dgoulet_at_vicr.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).
  • George Leonard (ZA) at Oct 2, 2002 at 4:18 pm
    Hi all


    Ok the trigger has been changed to this, It compiles.


    The problem now is that all the objects that need to be access is owner by
    the siebel user. I do not want to create synonyms. The tool being used can
    not append the siebel schema name in front of the objects, and it is
    expecting to log in as siebel.


    Any idea why the 'Alter session set CURRENT_SCHEMA = SIEBEL;' is not
    changing my current schema. I have tried executing Alter session set
    CURRENT_SCHEMA = SIEBEL; in a standard sqlplus window and then looking at
    the user_tables table and it is empty ?


    create or replace trigger olap1_logon_trigger
    after logon on smload.schema
    begin

    execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;';
    execute immediate 'Alter session enable parallel query;';
    execute immediate 'Alter session set SORT_AREA_SIZE = 10485760;';
    execute immediate 'Alter session set OPTIMIZER_MODE = choose;';
    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';

    end;
    /


    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za <http://www.didata.co.za>


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!
    -----Original Message-----
    Sent: 02 October 2002 16:52 PM
    To: ORACLE-L_at_fatcity.com
    Cc: george.leonard_at_za.didata.com


    George here is how we did ours"


    create or replace trigger olap1_logon_trigger
    after logon on olap1.schema
    begin
    execute immediate 'alter session set optimizer_mode = first_rows';
    end;
    /


    Customize it to your liking.


    Joe


    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.


    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.


    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.



    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: George Leonard (ZA)
    INET: George.Leonard_at_za.didata.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).
  • Vergara, Michael (TEM) at Oct 2, 2002 at 4:23 pm
    In looking at this and thinking about it...doesn't any DDL
    statement do an implied COMMIT? If so, the first "EXECUTE
    IMMEDIATE" will fire, commit, the SET TRANSACTION will be
    released, and the user will not be assured of using that
    rollback segment. Shouldn't the SET TRANSACTION be the
    last statement in the trigger?

    And if Siebel wants RBO, doesn't changing the optimizer at
    the session level mean that all that session's queries will
    be performed using CBO? Is Siebel OK with that?

    Cheers,
    Mike

    -----Original Message-----
    Sent: Wednesday, October 02, 2002 8:43 AM
    To: Multiple recipients of list ORACLE-L

    "Alter session ..." is not DML, so I think you need to use dynamic SQL:

    create or replace trigger smload.logon after logon on database
    begin
    SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;

    EXECUTE IMMEDIATE "Alter session enable parallel query";
    EXECUTE IMMEDIATE "Alter session set SORT_AREA_SIZE = 10485760";
    EXECUTE IMMEDIATE "Alter session set OPTIMIZER_MODE = choose";

    end;
    /

    Igor Neyman, OCP DBA
    ineyman_at_perceptron.com

    Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Wednesday, October 02, 2002 11:23 AM
    Hi guys

    I am trying to create the following trigger.

    The user in question is logging in using siebel application and siebel does
    not allow multiple SQL statements during login so we through this might
    solve the problem. My problem now is though, the set rollback works but the
    alter session statements does not seem to want to work.

    The server needs to be in RBO since this is the only mode supported by
    siebel.

    Help appreciated.

    create or replace trigger smload.logon after logon on database
    begin
    SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
    Alter session enable parallel query;
    Alter session set SORT_AREA_SIZE = 10485760;
    Alter session set OPTIMIZER_MODE = choose;
    end;
    /

    George
    ________________________________________________
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.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).
  • Igor Neyman at Oct 2, 2002 at 5:08 pm
    Altering "current_schema", you will not see anything in "user_tables", but you should be able to reference tables in this new schema without using "siebel" prefix.

    Igor Neyman, OCP DBA
    ineyman_at_perceptron.com


    Original Message -----
    From: George Leonard (ZA)
    To: Multiple recipients of list ORACLE-L
    Sent: Wednesday, October 02, 2002 12:18 PM
    Subject: RE: logon trigger

    Hi all



    Ok the trigger has been changed to this, It compiles.



    The problem now is that all the objects that need to be access is owner by the siebel user. I do not want to create synonyms. The tool being used can not append the siebel schema name in front of the objects, and it is expecting to log in as siebel.



    Any idea why the 'Alter session set CURRENT_SCHEMA = SIEBEL;' is not changing my current schema. I have tried executing Alter session set CURRENT_SCHEMA = SIEBEL; in a standard sqlplus window and then looking at the user_tables table and it is empty ?



    create or replace trigger olap1_logon_trigger

    after logon on smload.schema

    begin

    execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;';

    execute immediate 'Alter session enable parallel query;';

    execute immediate 'Alter session set SORT_AREA_SIZE = 10485760;';

    execute immediate 'Alter session set OPTIMIZER_MODE = choose;';

    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';



    end;

    /



    George

    George Leonard

    Oracle Database Administrator

    Dimension Data (Pty) Ltd

    (Reg. No. 1987/006597/07)

    Tel: (+27 11) 575 0573

    Fax: (+27 11) 576 0573

    E-mail:george.leonard_at_za.didata.com

    Web: http://www.didata.co.za



    You Have The Obligation to Inform One Honestly of the risk, And As a Person

    You Are Committed to Educate Yourself to the Total Risk In Any Activity!

    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit!

    -----Original Message-----
    From: JOE TESTA
    Sent: 02 October 2002 16:52 PM
    To: ORACLE-L_at_fatcity.com
    Cc: george.leonard_at_za.didata.com
    Subject: re: logon trigger



    George here is how we did ours"



    create or replace trigger olap1_logon_trigger
    after logon on olap1.schema
    begin
    execute immediate 'alter session set optimizer_mode = first_rows';
    end;
    /



    Customize it to your liking.



    Joe



    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Igor Neyman
    INET: ineyman_at_perceptron.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).
  • George Leonard (ZA) at Oct 3, 2002 at 6:58 am
    Hi Mike

    Siebel has released a note whereby they approve CBO for the EIM process.

    Also what I have is a SM Data warehouse logon into the OLTP Siebel db. The
    activities this logon does is more akin to OLAP. So what I am doing is
    giving this logon a big sort area size, enabling parallel access for the
    user, setting it's session to CBO etc etc.

    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!

    -----Original Message-----
    Sent: 02 October 2002 18:24 PM
    To: Multiple recipients of list ORACLE-L

    In looking at this and thinking about it...doesn't any DDL
    statement do an implied COMMIT? If so, the first "EXECUTE
    IMMEDIATE" will fire, commit, the SET TRANSACTION will be
    released, and the user will not be assured of using that
    rollback segment. Shouldn't the SET TRANSACTION be the
    last statement in the trigger?

    And if Siebel wants RBO, doesn't changing the optimizer at
    the session level mean that all that session's queries will
    be performed using CBO? Is Siebel OK with that?

    Cheers,
    Mike

    -----Original Message-----
    Sent: Wednesday, October 02, 2002 8:43 AM
    To: Multiple recipients of list ORACLE-L

    "Alter session ..." is not DML, so I think you need to use dynamic SQL:

    create or replace trigger smload.logon after logon on database
    begin
    SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;

    EXECUTE IMMEDIATE "Alter session enable parallel query";
    EXECUTE IMMEDIATE "Alter session set SORT_AREA_SIZE = 10485760";
    EXECUTE IMMEDIATE "Alter session set OPTIMIZER_MODE = choose";

    end;
    /

    Igor Neyman, OCP DBA
    ineyman_at_perceptron.com

    Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Wednesday, October 02, 2002 11:23 AM
    Hi guys

    I am trying to create the following trigger.

    The user in question is logging in using siebel application and siebel does
    not allow multiple SQL statements during login so we through this might
    solve the problem. My problem now is though, the set rollback works but the
    alter session statements does not seem to want to work.

    The server needs to be in RBO since this is the only mode supported by
    siebel.

    Help appreciated.

    create or replace trigger smload.logon after logon on database
    begin
    SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
    Alter session enable parallel query;
    Alter session set SORT_AREA_SIZE = 10485760;
    Alter session set OPTIMIZER_MODE = choose;
    end;
    /

    George
    ________________________________________________
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.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).

    ***************************************************************************************

    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.

    *************************************************************************************

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: George Leonard (ZA)
    INET: George.Leonard_at_za.didata.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).
  • George Leonard (ZA) at Oct 3, 2002 at 7:03 am
    Thx, I also found this last night.


    I will wait for the developers so arrive so that they can test their
    process.


    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za <http://www.didata.co.za>


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!
    -----Original Message-----
    Sent: 02 October 2002 19:09 PM
    To: Multiple recipients of list ORACLE-L


    Altering "current_schema", you will not see anything in "user_tables", but
    you should be able to reference tables in this new schema without using
    "siebel" prefix.


    Igor Neyman, OCP DBA
    ineyman_at_perceptron.com


    Original Message -----
    To: Multiple recipients of list ORACLE-L
    Sent: Wednesday, October 02, 2002 12:18 PM

    Hi all


    Ok the trigger has been changed to this, It compiles.


    The problem now is that all the objects that need to be access is owner by
    the siebel user. I do not want to create synonyms. The tool being used can
    not append the siebel schema name in front of the objects, and it is
    expecting to log in as siebel.


    Any idea why the 'Alter session set CURRENT_SCHEMA = SIEBEL;' is not
    changing my current schema. I have tried executing Alter session set
    CURRENT_SCHEMA = SIEBEL; in a standard sqlplus window and then looking at
    the user_tables table and it is empty ?


    create or replace trigger olap1_logon_trigger
    after logon on smload.schema
    begin

    execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;';
    execute immediate 'Alter session enable parallel query;';
    execute immediate 'Alter session set SORT_AREA_SIZE = 10485760;';
    execute immediate 'Alter session set OPTIMIZER_MODE = choose;';
    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';

    end;
    /


    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za <http://www.didata.co.za>


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!
    -----Original Message-----
    Sent: 02 October 2002 16:52 PM
    To: ORACLE-L_at_fatcity.com
    Cc: george.leonard_at_za.didata.com


    George here is how we did ours"


    create or replace trigger olap1_logon_trigger
    after logon on olap1.schema
    begin
    execute immediate 'alter session set optimizer_mode = first_rows';
    end;
    /


    Customize it to your liking.


    Joe


    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.

    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.


    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.


    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.



    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: George Leonard (ZA)
    INET: George.Leonard_at_za.didata.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).
  • George Leonard (ZA) at Oct 3, 2002 at 9:43 am
    Hi all


    Ok if I execute these commands/SQL in sqlplus it works. When I add to the
    trigger for after logon it does not work.


    I get the feeling it is only valid for the current block, begin -> End.


    Any ideas to work around this.


    grant alter session to smload;


    drop trigger olap_logon_trigger;
    create or replace trigger olapl_logon_trigger
    after logon on smload.schema
    begin
    execute immediate 'Alter session enable parallel query;';
    execute immediate 'Alter session set SORT_AREA_SIZE = 10485760;';

    execute immediate 'Alter session set OPTIMIZER_MODE = choose;';
    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';
    execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT

    RBBIG01;';

    end;
    /


    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za <http://www.didata.co.za>


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!
    -----Original Message-----
    Sent: 03 October 2002 09:03 AM
    To: Multiple recipients of list ORACLE-L


    Thx, I also found this last night.


    I will wait for the developers so arrive so that they can test their
    process.


    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za <http://www.didata.co.za>


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!
    -----Original Message-----
    Sent: 02 October 2002 19:09 PM
    To: Multiple recipients of list ORACLE-L


    Altering "current_schema", you will not see anything in "user_tables", but
    you should be able to reference tables in this new schema without using
    "siebel" prefix.


    Igor Neyman, OCP DBA
    ineyman_at_perceptron.com


    Original Message -----
    To: Multiple recipients of list ORACLE-L
    Sent: Wednesday, October 02, 2002 12:18 PM

    Hi all


    Ok the trigger has been changed to this, It compiles.


    The problem now is that all the objects that need to be access is owner by
    the siebel user. I do not want to create synonyms. The tool being used can
    not append the siebel schema name in front of the objects, and it is
    expecting to log in as siebel.


    Any idea why the 'Alter session set CURRENT_SCHEMA = SIEBEL;' is not
    changing my current schema. I have tried executing Alter session set
    CURRENT_SCHEMA = SIEBEL; in a standard sqlplus window and then looking at
    the user_tables table and it is empty ?


    create or replace trigger olap1_logon_trigger
    after logon on smload.schema
    begin

    execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;';
    execute immediate 'Alter session enable parallel query;';
    execute immediate 'Alter session set SORT_AREA_SIZE = 10485760;';
    execute immediate 'Alter session set OPTIMIZER_MODE = choose;';
    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';

    end;
    /


    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za <http://www.didata.co.za>


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!
    -----Original Message-----
    Sent: 02 October 2002 16:52 PM
    To: ORACLE-L_at_fatcity.com
    Cc: george.leonard_at_za.didata.com


    George here is how we did ours"


    create or replace trigger olap1_logon_trigger
    after logon on olap1.schema
    begin
    execute immediate 'alter session set optimizer_mode = first_rows';
    end;
    /


    Customize it to your liking.


    Joe


    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.

    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.

    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.


    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.


    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.



    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: George Leonard (ZA)
    INET: George.Leonard_at_za.didata.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).
  • Ron Thomas at Oct 3, 2002 at 5:23 pm
    FWIW, do not place the terminating semicolon in the execute string, ie,

    begin
    execute immediate 'Alter session set OPTIMIZER_MODE = choose';
    end;
    /

    Ron Thomas
    Hypercom, Inc
    rthomas_at_hypercom.com
    Each new user of a new system uncovers a new class of bugs. -- Kernighan

    root_at_fatcity.com
    To: ORACLE-L_at_fatcity.com
    10/03/02 02:43 AM cc:
    Please respond to Subject: RE: logon trigger
    ORACLE-L

    Hi all

    Ok if I execute these commands/SQL in sqlplus it works. When I add to the trigger for after logon it
    does not work.

    I get the feeling it is only valid for the current block, begin -> End.

    Any ideas to work around this.

    grant alter session to smload;

    drop trigger olap_logon_trigger;

    create or replace trigger olapl_logon_trigger

    after logon on smload.schema

    begin

    execute immediate 'Alter session enable parallel query;';

    execute immediate 'Alter session set SORT_AREA_SIZE = 10485760;';

    execute immediate 'Alter session set OPTIMIZER_MODE = choose;';

    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';

    execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;';

    end;

    /

    George

    George Leonard

    Oracle Database Administrator

    Dimension Data (Pty) Ltd

    (Reg. No. 1987/006597/07)

    Tel: (+27 11) 575 0573

    Fax: (+27 11) 576 0573

    E-mail:george.leonard_at_za.didata.com

    Web: http://www.didata.co.za

    You Have The Obligation to Inform One Honestly of the risk, And As a Person

    You Are Committed to Educate Yourself to the Total Risk In Any Activity!

    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as
    They See Fit!

    -----Original Message-----
    From: George Leonard (ZA)
    Sent: 03 October 2002 09:03 AM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: logon trigger

    Thx, I also found this last night.

    I will wait for the developers so arrive so that they can test their process.

    George

    ________________________________________________

    George Leonard

    Oracle Database Administrator

    Dimension Data (Pty) Ltd

    (Reg. No. 1987/006597/07)

    Tel: (+27 11) 575 0573

    Fax: (+27 11) 576 0573

    E-mail:george.leonard_at_za.didata.com

    Web: http://www.didata.co.za

    You Have The Obligation to Inform One Honestly of the risk, And As a Person

    You Are Committed to Educate Yourself to the Total Risk In Any Activity!

    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure
    Themselves as They See Fit!

    -----Original Message-----
    From: Igor Neyman
    Sent: 02 October 2002 19:09 PM
    To: Multiple recipients of list ORACLE-L
    Subject: Re: logon trigger

    Altering "current_schema", you will not see anything in "user_tables", but you should be
    able to reference tables in this new schema without using "siebel" prefix.

    Igor Neyman, OCP DBA
    ineyman_at_perceptron.com

    ----- Original Message -----

    From: George Leonard (ZA)

    To: Multiple recipients of list ORACLE-L

    Sent: Wednesday, October 02, 2002 12:18 PM

    Subject: RE: logon trigger

    Hi all

    Ok the trigger has been changed to this, It compiles.

    The problem now is that all the objects that need to be access is owner by the siebel
    user. I do not want to create synonyms. The tool being used can not append the siebel
    schema name in front of the objects, and it is expecting to log in as siebel.

    Any idea why the 'Alter session set CURRENT_SCHEMA = SIEBEL;' is not changing my
    current schema. I have tried executing Alter session set CURRENT_SCHEMA = SIEBEL; in a
    standard sqlplus window and then looking at the user_tables table and it is empty ?

    create or replace trigger olap1_logon_trigger

    after logon on smload.schema

    begin

    execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;';

    execute immediate 'Alter session enable parallel query;';

    execute immediate 'Alter session set SORT_AREA_SIZE = 10485760;';

    execute immediate 'Alter session set OPTIMIZER_MODE = choose;';

    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';

    end;

    /

    George

    ________________________________________________

    George Leonard

    Oracle Database Administrator

    Dimension Data (Pty) Ltd

    (Reg. No. 1987/006597/07)

    Tel: (+27 11) 575 0573

    Fax: (+27 11) 576 0573

    E-mail:george.leonard_at_za.didata.com

    Web: http://www.didata.co.za

    You Have The Obligation to Inform One Honestly of the risk, And As a Person

    You Are Committed to Educate Yourself to the Total Risk In Any Activity!

    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure
    Themselves as They See Fit!

    -----Original Message-----
    From: JOE TESTA
    Sent: 02 October 2002 16:52 PM
    To: ORACLE-L_at_fatcity.com
    Cc: george.leonard_at_za.didata..com
    Subject: re: logon trigger

    George here is how we did ours"

    create or replace trigger olap1_logon_trigger
    after logon on olap1.schema
    begin
    execute immediate 'alter session set optimizer_mode = first_rows';
    end;
    /

    Customize it to your liking.

    Joe

    ***************************************************************************************

    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.

    *************************************************************************************

    ***************************************************************************************

    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.

    *************************************************************************************

    ***************************************************************************************

    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Ron Thomas
    INET: rthomas_at_hypercom.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).
  • Aponte, Tony at Oct 4, 2002 at 1:28 am
    Do you happen to have that note number?

    Tony Aponte

    -----Original Message-----
    Sent: Thursday, October 03, 2002 2:58 AM
    To: Multiple recipients of list ORACLE-L

    Hi Mike

    Siebel has released a note whereby they approve CBO for the EIM process.

    Also what I have is a SM Data warehouse logon into the OLTP Siebel db. The
    activities this logon does is more akin to OLAP. So what I am doing is
    giving this logon a big sort area size, enabling parallel access for the
    user, setting it's session to CBO etc etc.

    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!

    -----Original Message-----
    Sent: 02 October 2002 18:24 PM
    To: Multiple recipients of list ORACLE-L

    In looking at this and thinking about it...doesn't any DDL
    statement do an implied COMMIT? If so, the first "EXECUTE
    IMMEDIATE" will fire, commit, the SET TRANSACTION will be
    released, and the user will not be assured of using that
    rollback segment. Shouldn't the SET TRANSACTION be the
    last statement in the trigger?

    And if Siebel wants RBO, doesn't changing the optimizer at
    the session level mean that all that session's queries will
    be performed using CBO? Is Siebel OK with that?

    Cheers,
    Mike

    -----Original Message-----
    Sent: Wednesday, October 02, 2002 8:43 AM
    To: Multiple recipients of list ORACLE-L

    "Alter session ..." is not DML, so I think you need to use dynamic SQL:

    create or replace trigger smload.logon after logon on database
    begin
    SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;

    EXECUTE IMMEDIATE "Alter session enable parallel query";
    EXECUTE IMMEDIATE "Alter session set SORT_AREA_SIZE = 10485760";
    EXECUTE IMMEDIATE "Alter session set OPTIMIZER_MODE = choose";

    end;
    /

    Igor Neyman, OCP DBA
    ineyman_at_perceptron.com

    Original Message -----
    To: "Multiple recipients of list ORACLE-L"
    Sent: Wednesday, October 02, 2002 11:23 AM
    Hi guys

    I am trying to create the following trigger.

    The user in question is logging in using siebel application and siebel does
    not allow multiple SQL statements during login so we through this might
    solve the problem. My problem now is though, the set rollback works but the
    alter session statements does not seem to want to work.

    The server needs to be in RBO since this is the only mode supported by
    siebel.

    Help appreciated.

    create or replace trigger smload.logon after logon on database
    begin
    SET TRANSACTION USE ROLLBACK SEGMENT RBBIG01;
    Alter session enable parallel query;
    Alter session set SORT_AREA_SIZE = 10485760;
    Alter session set OPTIMIZER_MODE = choose;
    end;
    /

    George
    ________________________________________________
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Vergara, Michael (TEM)
    INET: mvergara_at_guidant.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).

    ***************************************************************************************

    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.

    *************************************************************************************

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: George Leonard (ZA)
    INET: George.Leonard_at_za.didata.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.com
    --
    Author: Aponte, Tony
    INET: AponteT_at_hsn.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).
  • George Leonard (ZA) at Oct 4, 2002 at 6:58 am
    Hi there

    Your' the man, the people here laughed when we saw this working and that was
    the problem.

    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!

    -----Original Message-----
    Sent: 03 October 2002 19:24 PM
    To: Multiple recipients of list ORACLE-L

    FWIW, do not place the terminating semicolon in the execute string, ie,

    begin
    execute immediate 'Alter session set OPTIMIZER_MODE = choose';
    end;
    /

    Ron Thomas
    Hypercom, Inc
    rthomas_at_hypercom.com
    Each new user of a new system uncovers a new class of bugs. -- Kernighan



    root_at_fatcity.com

    To:
    ORACLE-L_at_fatcity.com
    10/03/02 02:43 AM cc:

    Please respond to Subject: RE: logon trigger

    ORACLE-L

    Hi all

    Ok if I execute these commands/SQL in sqlplus it works. When I add to the
    trigger for after logon it
    does not work.

    I get the feeling it is only valid for the current block, begin -> End.

    Any ideas to work around this.

    grant alter session to smload;

    drop trigger olap_logon_trigger;

    create or replace trigger olapl_logon_trigger

    after logon on smload.schema

    begin

    execute immediate 'Alter session enable parallel query;';

    execute immediate 'Alter session set SORT_AREA_SIZE = 10485760;';

    execute immediate 'Alter session set OPTIMIZER_MODE = choose;';

    execute immediate 'Alter session set CURRENT_SCHEMA = SIEBEL;';

    execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT
    RBBIG01;';

    end;

    /

    George

    George Leonard

    Oracle Database Administrator

    Dimension Data (Pty) Ltd

    (Reg. No. 1987/006597/07)

    Tel: (+27 11) 575 0573

    Fax: (+27 11) 576 0573

    E-mail:george.leonard_at_za.didata.com

    Web: http://www.didata.co.za

    You Have The Obligation to Inform One Honestly of the risk, And As a Person

    You Are Committed to Educate Yourself to the Total Risk In Any Activity!

    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as
    They See Fit!

    -----Original Message-----
    From: George Leonard (ZA)
    Sent: 03 October 2002 09:03 AM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: logon trigger

    Thx, I also found this last night.

    I will wait for the developers so arrive so that they can test their

    process.

    George

    George Leonard

    Oracle Database Administrator

    Dimension Data (Pty) Ltd

    (Reg. No. 1987/006597/07)

    Tel: (+27 11) 575 0573

    Fax: (+27 11) 576 0573

    E-mail:george.leonard_at_za.didata.com

    Web: http://www.didata.co.za

    You Have The Obligation to Inform One Honestly of the risk, And As a
    Person

    You Are Committed to Educate Yourself to the Total Risk In Any
    Activity!

    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to
    Kill or Injure

    Themselves as They See Fit!

    -----Original Message-----
    From: Igor Neyman
    Sent: 02 October 2002 19:09 PM
    To: Multiple recipients of list ORACLE-L
    Subject: Re: logon trigger

    Altering "current_schema", you will not see anything in
    "user_tables", but you should be
    able to reference tables in this new schema without using

    "siebel" prefix.

    Igor Neyman, OCP DBA
    ineyman_at_perceptron.com

    ----- Original Message -----

    From: George Leonard (ZA)

    To: Multiple recipients of list ORACLE-L

    Sent: Wednesday, October 02, 2002 12:18 PM

    Subject: RE: logon trigger

    Hi all

    Ok the trigger has been changed to this, It compiles.

    The problem now is that all the objects that need to be access
    is owner by the siebel
    user. I do not want to create synonyms. The tool being used can
    not append the siebel
    schema name in front of the objects, and it is expecting to log

    in as siebel.

    Any idea why the 'Alter session set CURRENT_SCHEMA = SIEBEL;'
    is not changing my

    current schema. I have tried executing Alter session set
    CURRENT_SCHEMA = SIEBEL; in a

    standard sqlplus window and then looking at the user_tables
    table and it is empty ?

    create or replace trigger olap1_logon_trigger

    after logon on smload.schema

    begin

    execute immediate 'SET TRANSACTION USE ROLLBACK SEGMENT
    RBBIG01;';

    execute immediate 'Alter session enable parallel query;';

    execute immediate 'Alter session set SORT_AREA_SIZE =
    10485760;';

    execute immediate 'Alter session set OPTIMIZER_MODE =

    choose;';

    execute immediate 'Alter session set CURRENT_SCHEMA =

    SIEBEL;';

    end;

    /

    George

    George Leonard

    Oracle Database Administrator

    Dimension Data (Pty) Ltd

    (Reg. No. 1987/006597/07)

    Tel: (+27 11) 575 0573

    Fax: (+27 11) 576 0573

    E-mail:george.leonard_at_za.didata.com

    Web: http://www.didata.co.za

    You Have The Obligation to Inform One Honestly of the risk, And
    As a Person

    You Are Committed to Educate Yourself to the Total Risk In Any
    Activity!

    Once Informed & Totally Aware of the Risk, Every Fool Has the
    Right to Kill or Injure

    Themselves as They See Fit!

    -----Original Message-----
    From: JOE TESTA
    Sent: 02 October 2002 16:52 PM
    To: ORACLE-L_at_fatcity.com
    Cc: george.leonard_at_za.didata..com
    Subject: re: logon trigger

    George here is how we did ours"

    create or replace trigger olap1_logon_trigger
    after logon on olap1.schema
    begin
    execute immediate 'alter session set optimizer_mode =
    first_rows';
    end;
    /

    Customize it to your liking.

    Joe

    ****************************************************************************

    This message contains information intended solely for the
    addressee,

    which is confidential or private in nature and subject to legal
    privilege.

    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file
    attached to this
    message. Any such unauthorised use is prohibited and may be
    unlawful. If
    you have received this message in error, please notify the
    sender
    immediately by e-mail, facsimile or telephone and thereafter
    delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may
    contain the
    personal views and opinions of the author, which are not
    necessarily the
    views and opinions of Dimension Data (South Africa)
    (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension
    Data"). Dimension
    Data therefore does not accept liability for any claims, loss
    or damages
    of whatsoever nature, arising as a result of the reliance on
    such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy
    and
    integrity of information transmitted electronically and to
    preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for
    whatsoever
    reason, incorrect, corrupted or does not reach its intended

    destination.





    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal
    privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to
    this
    message. Any such unauthorised use is prohibited and may be unlawful.
    If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete
    the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain
    the
    personal views and opinions of the author, which are not necessarily
    the
    views and opinions of Dimension Data (South Africa) (Proprietary)
    Limited
    or its subsidiaries and associated companies ("Dimension Data").
    Dimension
    Data therefore does not accept liability for any claims, loss or
    damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve
    the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended

    destination.



    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Ron Thomas
    INET: rthomas_at_hypercom.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).

    ***************************************************************************************

    This message contains information intended solely for the addressee,
    which is confidential or private in nature and subject to legal privilege.
    If you are not the intended recipient, you may not peruse, use,
    disseminate, distribute or copy this message or any file attached to this
    message. Any such unauthorised use is prohibited and may be unlawful. If
    you have received this message in error, please notify the sender
    immediately by e-mail, facsimile or telephone and thereafter delete the
    original message from your machine.

    Furthermore, the information contained in this message, and any
    attachments thereto, is for information purposes only and may contain the
    personal views and opinions of the author, which are not necessarily the
    views and opinions of Dimension Data (South Africa) (Proprietary) Limited
    or its subsidiaries and associated companies ("Dimension Data"). Dimension
    Data therefore does not accept liability for any claims, loss or damages
    of whatsoever nature, arising as a result of the reliance on such
    information by anyone.

    Whilst all reasonable steps are taken to ensure the accuracy and
    integrity of information transmitted electronically and to preserve the
    confidentiality thereof, Dimension Data accepts no liability or
    responsibility whatsoever if information or data is, for whatsoever
    reason, incorrect, corrupted or does not reach its intended destination.

    *************************************************************************************

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: George Leonard (ZA)
    INET: George.Leonard_at_za.didata.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).
  • Mkb at Oct 29, 2002 at 5:29 pm
    Sorry in advance, but I didn't think I'd need this.

    There was a discussion about 4 weeks ago if memory
    serves correct, about denying users logging on to
    Oracle directly either through SQL*Plus or other tools
    such as TOAD. Tried searching the archives but
    getting too many hits.

    Someone posted trigger code that did this. Anyone
    have a copy of this?

    Thanks

    mkb

    Do you Yahoo!?
    HotJobs - Search new jobs daily now
    http://hotjobs.yahoo.com/
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: mkb
    INET: mkb125_at_yahoo.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).
  • Ramon E. Estevez at Oct 30, 2002 at 8:33 pm
    Hi, mkb

    I made this one, hope it works for you as it did for me.

    It validates also some roles that were assigned to the DBA group.

    Luck,

    Ramonaa

    CREATE OR REPLACE TRIGGER sys.Block_Tools_T
    after logon on database

    Declare
    user_name varchar2(30);
    program_name varchar2(40);
    machine_name varchar2(40);
    logon_date date;
    sesiones integer := 0;
    autorizado varchar2(1) := 'N';
    external_tool boolean := false;

    cursor c1 is select username, program, machine, sysdate

    from v$session
    where audsid=userenv('sessionid');

    Begin
    open c1;
    fetch c1 into user_name, program_name, machine_name, logon_date;
    close c1;

    select count(*) into sesiones
    from v$session
    where username = user_name
    and machine = machine_name;

    select 'S' into autorizado from dba_role_privs
    where grantee = user_name
    and granted_role in
    ('DBA_JUNIOR','DBA_SENIOR','INTEGRIDAD','ANALISTA_TEM');

    if upper(program_name) LIKE '%PLUS%' or
    upper(program_name) LIKE '%TOAD%' or
    upper(program_name) LIKE 'SQLNAV%' then
    external_tool := true;

    end if;
    if (external_tool and autorizado = 'N') then

    raise_application_error(-20001,'Usted No puede conectarse
    utilizando esta aplicacion.');
    elsif (autorizado = 'N' and sesiones >= 1) then

    raise_application_error(-20001,'No puede hacer mas conexiones desde
    esta terminal.');
    end if;

    Exception when others then
    raise_application_error(-20001,'No tiene ningun privilegio asignado,
    contacte el depto de seguridad de sistemas.');
    End;
    /

    -----Original Message-----
    Sent: Tuesday, October 29, 2002 12:29 PM
    To: Multiple recipients of list ORACLE-L

    Sorry in advance, but I didn't think I'd need this.

    There was a discussion about 4 weeks ago if memory
    serves correct, about denying users logging on to
    Oracle directly either through SQL*Plus or other tools
    such as TOAD. Tried searching the archives but
    getting too many hits.

    Someone posted trigger code that did this. Anyone
    have a copy of this?

    Thanks

    mkb

    Do you Yahoo!?
    HotJobs - Search new jobs daily now
    http://hotjobs.yahoo.com/
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: mkb
    INET: mkb125_at_yahoo.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.com
    --
    Author: Ramon E. Estevez
    INET: com.banilejas_at_codetel.net.do

    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).
  • Joe Testa at Oct 30, 2002 at 9:18 pm
    Ramon, a few quick comments.

    Never create an object owned by SYS. It just isn't good to
    contaminate the SYS schema with NON oracle related objects.
    Anything owned by SYS will NOT be exported, refer to #1.
    Create a new userid to store those kinds of objects so during an
    export it will be picked up and refer to #1. :)

    joe

    Ramon E. Estevez wrote:
    Hi, mkb

    I made this one, hope it works for you as it did for me.

    It validates also some roles that were assigned to the DBA group.


    Luck,

    Ramonaa

    ----------------------------------------------------------------
    CREATE OR REPLACE TRIGGER sys.Block_Tools_T
    after logon on database

    Declare
    user_name varchar2(30);
    program_name varchar2(40);
    machine_name varchar2(40);
    logon_date date;
    sesiones integer := 0;
    autorizado varchar2(1) := 'N';
    external_tool boolean := false;

    cursor c1 is select username, program, machine, sysdate
    from v$session
    where audsid=userenv('sessionid');
    Begin
    open c1;
    fetch c1 into user_name, program_name, machine_name, logon_date;
    close c1;

    select count(*) into sesiones
    from v$session
    where username = user_name
    and machine = machine_name;

    select 'S' into autorizado from dba_role_privs
    where grantee = user_name
    and granted_role in
    ('DBA_JUNIOR','DBA_SENIOR','INTEGRIDAD','ANALISTA_TEM');
    if upper(program_name) LIKE '%PLUS%' or
    upper(program_name) LIKE '%TOAD%' or
    upper(program_name) LIKE 'SQLNAV%' then
    external_tool := true;
    end if;
    if (external_tool and autorizado = 'N') then
    raise_application_error(-20001,'Usted No puede conectarse
    utilizando esta aplicacion.');
    elsif (autorizado = 'N' and sesiones >= 1) then
    raise_application_error(-20001,'No puede hacer mas conexiones desde
    esta terminal.');
    end if;

    Exception when others then
    raise_application_error(-20001,'No tiene ningun privilegio asignado,
    contacte el depto de seguridad de sistemas.');
    End;
    /



    -----Original Message-----
    Sent: Tuesday, October 29, 2002 12:29 PM
    To: Multiple recipients of list ORACLE-L


    Sorry in advance, but I didn't think I'd need this.

    There was a discussion about 4 weeks ago if memory
    serves correct, about denying users logging on to
    Oracle directly either through SQL*Plus or other tools
    such as TOAD. Tried searching the archives but
    getting too many hits.

    Someone posted trigger code that did this. Anyone
    have a copy of this?

    Thanks

    mkb


    __________________________________________________
    Do you Yahoo!?
    HotJobs - Search new jobs daily now
    http://hotjobs.yahoo.com/
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Joe Testa
    INET: jtesta_at_dmc-it.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).
  • Mkb at Oct 30, 2002 at 10:18 pm
    Ramon,

    Thank you. I like the ideas in this trigger. I will
    certainly try this.

    mkb

    "Ramon E. Estevez"
    wrote:
    Hi, mkb

    I made this one, hope it works for you as it did for
    me.

    It validates also some roles that were assigned to
    the DBA group.


    Luck,

    Ramonaa

    CREATE OR REPLACE TRIGGER sys.Block_Tools_T
    after logon on database

    Declare
    user_name varchar2(30);
    program_name varchar2(40);
    machine_name varchar2(40);
    logon_date date;
    sesiones integer := 0;
    autorizado varchar2(1) := 'N';
    external_tool boolean := false;

    cursor c1 is select username, program, machine,
    sysdate
    from v$session
    where audsid=userenv('sessionid');
    Begin
    open c1;
    fetch c1 into user_name, program_name,
    machine_name, logon_date;
    close c1;

    select count(*) into sesiones
    from v$session
    where username = user_name
    and machine = machine_name;

    select 'S' into autorizado from dba_role_privs
    where grantee = user_name
    and granted_role in
    ('DBA_JUNIOR','DBA_SENIOR','INTEGRIDAD','ANALISTA_TEM');
    if upper(program_name) LIKE '%PLUS%' or
    upper(program_name) LIKE '%TOAD%' or
    upper(program_name) LIKE 'SQLNAV%' then
    external_tool := true;
    end if;
    if (external_tool and autorizado = 'N') then
    raise_application_error(-20001,'Usted No puede
    conectarse
    utilizando esta aplicacion.');
    elsif (autorizado = 'N' and sesiones >= 1) then
    raise_application_error(-20001,'No puede hacer
    mas conexiones desde
    esta terminal.');
    end if;

    Exception when others then
    raise_application_error(-20001,'No tiene ningun
    privilegio asignado,
    contacte el depto de seguridad de sistemas.');
    End;
    /



    -----Original Message-----
    Sent: Tuesday, October 29, 2002 12:29 PM
    To: Multiple recipients of list ORACLE-L


    Sorry in advance, but I didn't think I'd need this.

    There was a discussion about 4 weeks ago if memory
    serves correct, about denying users logging on to
    Oracle directly either through SQL*Plus or other
    tools
    such as TOAD. Tried searching the archives but
    getting too many hits.

    Someone posted trigger code that did this. Anyone
    have a copy of this?

    Thanks

    mkb


    __________________________________________________
    Do you Yahoo!?
    HotJobs - Search new jobs daily now
    http://hotjobs.yahoo.com/
    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: mkb
    INET: mkb125_at_yahoo.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.com
    --
    Author: Ramon E. Estevez
    INET: com.banilejas_at_codetel.net.do

    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).
    Do you Yahoo!?
    HotJobs - Search new jobs daily now
    http://hotjobs.yahoo.com/

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: mkb
    INET: mkb125_at_yahoo.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).
  • Ramon E. Estevez at Oct 31, 2002 at 1:23 pm
    Thanks Joe.

    -----Original Message-----
    Sent: Wednesday, October 30, 2002 4:18 PM
    To: Multiple recipients of list ORACLE-L

    Ramon, a few quick comments.

    Never create an object owned by SYS. It just isn't good to
    contaminate the SYS schema with NON oracle related objects.
    Anything owned by SYS will NOT be exported, refer to #1.
    Create a new userid to store those kinds of objects so during an
    export it will be picked up and refer to #1. :)

    joe

    Ramon E. Estevez wrote:
    Hi, mkb

    I made this one, hope it works for you as it did for me.

    It validates also some roles that were assigned to the DBA group.


    Luck,

    Ramonaa

    ----------------------------------------------------------------
    CREATE OR REPLACE TRIGGER sys.Block_Tools_T
    after logon on database

    Declare
    user_name varchar2(30);
    program_name varchar2(40);
    machine_name varchar2(40);
    logon_date date;
    sesiones integer := 0;
    autorizado varchar2(1) := 'N';
    external_tool boolean := false;

    cursor c1 is select username, program, machine, sysdate
    from v$session
    where audsid=userenv('sessionid');
    Begin
    open c1;
    fetch c1 into user_name, program_name, machine_name, logon_date;
    close c1;

    select count(*) into sesiones
    from v$session
    where username = user_name
    and machine = machine_name;

    select 'S' into autorizado from dba_role_privs
    where grantee = user_name
    and granted_role in
    ('DBA_JUNIOR','DBA_SENIOR','INTEGRIDAD','ANALISTA_TEM');
    if upper(program_name) LIKE '%PLUS%' or
    upper(program_name) LIKE '%TOAD%' or
    upper(program_name) LIKE 'SQLNAV%' then
    external_tool := true;
    end if;
    if (external_tool and autorizado = 'N') then
    raise_application_error(-20001,'Usted No puede conectarse
    utilizando esta aplicacion.');
    elsif (autorizado = 'N' and sesiones >= 1) then
    raise_application_error(-20001,'No puede hacer mas conexiones
    desde esta terminal.');
    end if;

    Exception when others then
    raise_application_error(-20001,'No tiene ningun privilegio
    asignado, contacte el depto de seguridad de sistemas.'); End;
    /



    -----Original Message-----
    Sent: Tuesday, October 29, 2002 12:29 PM
    To: Multiple recipients of list ORACLE-L


    Sorry in advance, but I didn't think I'd need this.

    There was a discussion about 4 weeks ago if memory
    serves correct, about denying users logging on to
    Oracle directly either through SQL*Plus or other tools
    such as TOAD. Tried searching the archives but
    getting too many hits.

    Someone posted trigger code that did this. Anyone
    have a copy of this?

    Thanks

    mkb


    __________________________________________________
    Do you Yahoo!?
    HotJobs - Search new jobs daily now
    http://hotjobs.yahoo.com/
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Joe Testa
    INET: jtesta_at_dmc-it.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.com
    --
    Author: Ramon E. Estevez
    INET: com.banilejas_at_codetel.net.do

    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).
  • Ramon E. Estevez at Oct 31, 2002 at 1:23 pm
    Mkb, think about the JOE considerations !!

    -----Original Message-----
    Sent: Wednesday, October 30, 2002 5:19 PM
    To: Multiple recipients of list ORACLE-L

    Ramon,

    Thank you. I like the ideas in this trigger. I will
    certainly try this.

    mkb

    "Ramon E. Estevez"
    wrote:
    Hi, mkb

    I made this one, hope it works for you as it did for
    me.

    It validates also some roles that were assigned to
    the DBA group.


    Luck,

    Ramonaa

    CREATE OR REPLACE TRIGGER sys.Block_Tools_T
    after logon on database

    Declare
    user_name varchar2(30);
    program_name varchar2(40);
    machine_name varchar2(40);
    logon_date date;
    sesiones integer := 0;
    autorizado varchar2(1) := 'N';
    external_tool boolean := false;

    cursor c1 is select username, program, machine,
    sysdate
    from v$session
    where audsid=userenv('sessionid');
    Begin
    open c1;
    fetch c1 into user_name, program_name,
    machine_name, logon_date;
    close c1;

    select count(*) into sesiones
    from v$session
    where username = user_name
    and machine = machine_name;

    select 'S' into autorizado from dba_role_privs
    where grantee = user_name
    and granted_role in
    ('DBA_JUNIOR','DBA_SENIOR','INTEGRIDAD','ANALISTA_TEM');
    if upper(program_name) LIKE '%PLUS%' or
    upper(program_name) LIKE '%TOAD%' or
    upper(program_name) LIKE 'SQLNAV%' then
    external_tool := true;
    end if;
    if (external_tool and autorizado = 'N') then
    raise_application_error(-20001,'Usted No puede conectarse
    utilizando esta aplicacion.');
    elsif (autorizado = 'N' and sesiones >= 1) then
    raise_application_error(-20001,'No puede hacer
    mas conexiones desde
    esta terminal.');
    end if;

    Exception when others then
    raise_application_error(-20001,'No tiene ningun privilegio
    asignado, contacte el depto de seguridad de sistemas.');
    End;
    /



    -----Original Message-----
    Sent: Tuesday, October 29, 2002 12:29 PM
    To: Multiple recipients of list ORACLE-L


    Sorry in advance, but I didn't think I'd need this.

    There was a discussion about 4 weeks ago if memory
    serves correct, about denying users logging on to
    Oracle directly either through SQL*Plus or other
    tools
    such as TOAD. Tried searching the archives but
    getting too many hits.

    Someone posted trigger code that did this. Anyone
    have a copy of this?

    Thanks

    mkb


    __________________________________________________
    Do you Yahoo!?
    HotJobs - Search new jobs daily now
    http://hotjobs.yahoo.com/
    --
    Please see the official ORACLE-L FAQ:
    http://www.orafaq.com
    --
    Author: mkb
    INET: mkb125_at_yahoo.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.com
    --
    Author: Ramon E. Estevez
    INET: com.banilejas_at_codetel.net.do

    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).
    Do you Yahoo!?
    HotJobs - Search new jobs daily now
    http://hotjobs.yahoo.com/

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: mkb
    INET: mkb125_at_yahoo.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.com
    --
    Author: Ramon E. Estevez
    INET: com.banilejas_at_codetel.net.do

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

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 2, '02 at 3:23p
activeOct 31, '02 at 1:23p
posts21
users12
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase