Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Transaction, Oracle

Re: Transaction, Oracle

From: Oliver Otto <ootto_at_genese.de>
Date: Tue, 17 Dec 2002 19:25:22 +0100
Message-ID: <3DFF6C12.DE402F6C@genese.de>


Hallo,

we know this from our basicly used database. We use this behaviour to do our database updates. The main reason is that we can rollback all database modification if the update-function run into an error and the user is able to use the previous version.

It is the best thing you can do. Or do you have another idea for this ..?!

Greetings

Oliver

Niall Litchfield wrote:

> "Oliver Otto" <ootto_at_genese.de> wrote in message
> news:3DFDD673.20424043_at_genese.de...
> > Hallo ,
> >
> > is it really not possible to use transactions with table commands ..? We
> > use Oracle 9i and would like to use a rollback in the case if an "alter
> > table yxz add column vwq" result in an error.
>
> The answer to the question I think you are asking is No. I.E. You can't do
> something like
>
> begin
> <some dml>;
> <some ddl>;
> end;
>
> In fact technically the answer is yes since any DDL statement is a self
> contained transaction eg create table tab(col1 number); becomes
> commit;create table tab(col1 number);commit;
>
> I would question what on earth you were doing redefining tables in a
> transaction anyway, if they are temporary tables to store intermediate
> results you almost certainly don't need them.
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************


Received on Tue Dec 17 2002 - 12:25:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US