Re: How to crash Your instance with simple CTAS

From: Grzegorz Goryszewski <>
Date: Thu, 01 Dec 2011 20:44:14 +0100
Message-ID: <>

On 2011-12-01 20:34, Rich Jesse wrote:
> Even simpler, forget the CTA part and run just the SELECT. It may be
> related to the fact that DBMS_RANDOM.VALUE returns a non-whole number 0<=1,
> which doesn't probably do what you were hoping it to do. But I was only
> able to get it to fail when some MINUS clause was used (the WHERE clause
> didn't seem to matter).
> In any case, it shouldn't disconnect the session...
> Nice one!

Thats true , minus is necessary and order by dbms_random.value . Not sure about create table thou.
Received on Thu Dec 01 2011 - 13:44:14 CST

Original text of this message