Yosi
I have tested and found CTAS use rollback.
Thanks
-Seema
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: rollback use query
Date: Mon, 11 Jun 2001 13:20:27 -0800
I'd hate to argue with Anita, but I'm pretty sure
, 2001 4:20 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: rollback use query
I'd hate to argue with Anita, but I'm pretty sure
that rollback
won't be used on CTAS, since it's ddl.
Somebody verify or correct please?
Thanx,
Yosi
-Original Message
of list ORACLE-L
Subject: RE: rollback use query
Kirti and Yosi,
It's a good idea to not argue with Anita! :)
Oh puhleeze!! Argue with me all you want,
especially when I'm wrong. I'm a big girl, I can take
it ;) Now if you want to convince my boyfriend not to
argue with me
To: Multiple recipients of list ORACLE-L
Subject: RE: rollback use query
Kirti and Yosi,
It's a good idea to not argue with Anita! :)
Oh puhleeze!! Argue with me all you want,
especially when I'm wrong. I'm a big girl, I can take
it ;) Now if you want to convince my boyfriend
I'd hate to argue with Anita, but I'm pretty sure that rollback
won't be used on CTAS, since it's ddl.
Somebody verify or correct please?
Thanx,
Yosi
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 1:21 PM
To: Multiple recipients of
,
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 11, 2001 4:20 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: rollback use query
I'd hate to argue
Hi Yosi,
I'd hate to argue with Anita, but I'm pretty sure that rollback
won't be used on CTAS, since it's ddl.
CTAS or any DDL for that matter *will* need to write to SYS tables - (UET$,
FET$ in this simple case as it needs to preserve information about extents
allocated, etc.) and this