Auto Commit - Urgent
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Auto Commit - Urgent

  1. #1
    Join Date
    Sep 2000
    Posts
    14

    Question

    Hi,

    Apart from setting Auto commit in Sql*plus are there any other ways to set Auto commit in Oracle 8.1.6?

    mcl

  2. #2
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    It sets a flag someware, but i don't know where. So probably there are other (system) ways of putting it.

  3. #3
    Join Date
    Sep 2000
    Posts
    43
    Do you want to commit after a certain period of time? Is it through just SQL*Plus or through a program or SQL*Load? You need to give more details otherwise the answer to your question is already given :-)
    Alla S. Pfauntsch
    Oracle DBA
    ========================================
    "Life is what happens while you are planning something else".

  4. #4
    Join Date
    Sep 2000
    Posts
    14

    more infor

    more infor for you guys........
    Our software interacts with Oracle and we want to find out how we can set up and turn off auto commit apart from within SQL*PLUS. Informix have auto commit as default and we can override it when we start a new transaction from our software. Can I do the same in Oracle ? Or I have to explicitly set auto commit off?


  5. #5
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    Each time you enter sqlplus ORACLE looks for a file in your current directory called login.sql. In this file you can place any SQL*Plus command that you wish to be globally applied to your work. Thus to save typing in common format or page commands at each session they can all be placed in a file called 'login.sql'. So you can add the param set autocommit on. A typical file might be:

    SET PAGESIZE 22
    SET PAUSE ON
    SET PAUSE "Press <ENTER> for next page"
    SET PAUSE "Press <E>
    SET NUMF 999999
    COL ENAME FORMAT A15
    COL SAL FORMAT 99,999.99

    If you enter sqlplus from a directory level other than that in which the file login.sql has been placed, ORACLE will not find it and the settings will not be applied.
    P.s autocommit is not recomanded.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width