Re: How to crash Your instance <-- should be session ---with simple CTAS

  • From: TESTAJ3@xxxxxxxxxxxxxx
  • To: cicciuxdba@xxxxxxxxx
  • Date: Thu, 1 Dec 2011 15:28:16 -0500

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


Other related posts: