Re: [Info-ingres] Friday is coming ...

Hi Michael

> 1. I don't disagree with you. I'm just trying to make trouble.

Excellent, this is a decent thing to do and something of which
your mother would be proud.
>
> 2. As you probably know, Oracle DDL statements, while atomic,
> are not transaction friendly. Executing a DDL statement issues
> an implicit commit within the Oracle engine. I was pointing out
> the the customer how evil this is, but they couldn't understand
> why. *Sigh*

Customers are fools, programmers are evil.

I believe Roy has had much to say on this.
>
> Just to be clear, in Oracle, this SQL sequence results in a row
> actually existing in the wow table and the wow2 table exists as
> well.
>
> create table wow(neato varchar2(20));
> commit;
> insert into wow values ('Mike');
> create table wow2(neato varchar2(20));
> rollback;
> select * from wow;
> commit;
>
> Now that's just wrong.

It actually achieves the rare double of both sucking and
blowing.

Marty
.

Relevant Pages

  • Re: Why Oracle does not allow rollback of DDL statements?
    ... DDL statements are executed. ... I was learning SQL Server few months ago and I noticed that SQL Server ... like there is something in Oracle architecture which prevents rollback ... in Oracle you don't execute DDL statements on the fly. ...
    (comp.databases.oracle.server)
  • Re: Why Oracle does not allow rollback of DDL statements?
    ... DDL statements are executed. ... does allow rollback of DDL statements if I am not mistaken. ... Part of why Oracle is different than other DBMS engines is its ... I don't know the real reason you can't rollback DDL, ...
    (comp.databases.oracle.server)
  • Re: Creating schema in oracle10g express edition
    ... Oracle has two different DDL statements: ... There are a bunch of caveats in the documentation for create schema. ... thread and ignore "create schema" in oracle. ...
    (comp.databases.oracle.server)
  • Re: Why Oracle does not allow rollback of DDL statements?
    ... does allow rollback of DDL statements if I am not mistaken. ... Actually, Oracle does 2 commits, one each before and after the DDL. ... I don't know the real reason you can't rollback DDL, ...
    (comp.databases.oracle.server)
  • Re: [Info-ingres] Friday is coming ...
    ... maybe we should wait for Roy to come back from vacation before ... As you probably know, Oracle DDL statements, while atomic, ... an implicit commit within the Oracle engine. ...
    (comp.databases.ingres)