How to crash Your instance with simple CTAS

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