Re: How to crash Your instance with simple CTAS

From: Rich Jesse <>
Date: Thu, 1 Dec 2011 13:34:37 -0600 (CST)
Message-ID: <>

> 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 instance as well :).
> Dont ask me how do I know :)

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!


Received on Thu Dec 01 2011 - 13:34:37 CST

Original text of this message