Content-Type: text/plain; charset="US-ASCII" see subject name change From: Guillermo Alan Bort <cicciuxdba@xxxxxxxxx> To: grzegorzof@xxxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Date: 12/01/2011 02:18 PM Subject: Re: How to crash Your instance with simple CTAS Sent by: oracle-l-bounce@xxxxxxxxxxxxx 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@xxxxxxxxxx>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 > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l