Oracle Tools - Auto Commit Feature

**mcstock** · Jun 27 '08, 05:24 PM

Re: Oracle Tools - Auto Commit Feature

you don't really have a production environment unless you have an
application interface other than an ad hoc SQL interface

you should at least use something like MS-Access via ODBC to give the users
a reasonable way to insert/update/delete and search data -- or have some
PL/SQL stored procedures to control the transactions (COMMITS can be coded
into the stored procedures) or at very least some script files

meanwhile, SQL*Plus (which is what SQL Worksheet runs behind its Java UI)
has an AUTOCOMMIT feature which can be set in the global login file --
however, this commits after EVERY individual DML statement -- so if you've
got users typing in stuff like

delete from sales where sales_period = 47;

and they accidentally type

delete from sales;

there is no way (as in no way) to recover the lost data without
point-in-time database recovery

what is your 'production' environment? intranet? client/server? character
terminals? if you could post or email some more specifics, i could provide
some recommendations
----------------------------------------
Mark C. Stock

Site Not Found | Framer

https://www.enquery.com

(888) 512-2048

"DBAGUY" <kirkens@yahoo. comwrote in message
news:b62aa846.0 310221357.2c2e1 41a@posting.goo gle.com...

Any tools out there someone would recommend for Oracle. Currently
users are utilizing SQL Worksheet in the production environment to
help support the clients needs. They have continuously forgotten to
issue commits during monthly processing which affects their production
cycle.
>
Besides coding one myself. Is there a dumbed down version of an Oracle
tool that will issue autocommits?

Oracle Tools - Auto Commit Feature

Oracle Tools - Auto Commit Feature

Comment