Re: How to crash Your instance with simple CTAS

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Thu, 1 Dec 2011 16:17:17 -0300
Message-ID: <CAJ2dSGS_anMW7gp3gHnrEB6w_wCWscG_=b6LDYq+SyW+v9OTfw_at_mail.gmail.com>

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

Received on Thu Dec 01 2011 - 13:17:17 CST