RE: How to crash Your instance <-- should be session ---with simple CTAS
Date: Thu, 1 Dec 2011 15:41:07 -0500
Message-Id: <20111201212427.93218E64A60_at_turing.freelists.org>
Neither the session or the instance is affected for me. V. 11.1.0.7. I just get an error but can continue working in the session.
At the bottom is mentioned the versions; 9,10,11. Why pick on 10.2.0.3 specifically, though?
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
TESTAJ3_at_nationwide.com
Sent: Thursday, December 01, 2011 3:28 PM
To: cicciuxdba_at_gmail.com
Cc: grzegorzof_at_interia.pl; oracle-l_at_freelists.org;
oracle-l-bounce_at_freelists.org
Subject: Re: How to crash Your instance <-- should be session ---with
simple CTAS
Content-Type: text/plain; charset="US-ASCII" see subject name change
From:
Guillermo Alan Bort <cicciuxdba_at_gmail.com>
To:
grzegorzof_at_interia.pl
Cc:
oracle-l_at_freelists.org
Date:
12/01/2011 02:18 PM
Subject:
Re: How to crash Your instance with simple CTAS
Sent by:
oracle-l-bounce_at_freelists.org
I'm tempted to test that in one of our DBs... but I'll wait till I get
home
to my testing sandbox :D
cheers
Alan.-
On Thu, Dec 1, 2011 at 3:52 PM, Grzegorz Goryszewski <grzegorzof_at_interia.pl>wrote:
> Hi,
>
> something like that
>
> create table t as (select * from dba_users minus select * from
dba_users
> where mod(user_id,2) = 0 ) order by dbms_random.value
>
> can crash You session in 9,10,11 and in 10.2.0.3 instance as well :).
> Dont ask me how do I know :)
> Regards
> GregG
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Dec 01 2011 - 14:41:07 CST