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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of TESTAJ3@xxxxxxxxxxxxxx Sent: Thursday, December 01, 2011 3:28 PM To: cicciuxdba@xxxxxxxxx Cc: grzegorzof@xxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx 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@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 -- //www.freelists.org/webpage/oracle-l