Re: how to find if a session is resumable

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Sat, 13 Mar 2004 06:33:22 +1100
Message-ID: <40521089$0$8354$afc38c87@news.optusnet.com.au>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1079112419.439654_at_yasure...

>
> Is there any way to create a demo that would allow students to be shown
> the difference between a resumable session and a non-resumable session?
> Any suggestions will be appreciated. Code even more so.
>

Scenario One:

connect scott/tiger
create tablespace X datafile 'xxxxx' size 2M; create table bigemp tablespace X as select * from emp; insert into bigemp select * from bigemp;
/
/
/
/
/

SQL ERROR: Unable to extend bigemp by Y in tablespace X.

Scenario Two:
connect scott/tiger
alter session enable resumable;
create tablespace X datafile 'xxxxx' size 2M; create table bigemp tablespace X as select * from emp; insert into bigemp select * from bigemp;
/
/
/
/
/

<Dirty Great Pause>

Run off to the alert log at this point to tail it.

Works well enough for me.

Regards
HJR Received on Fri Mar 12 2004 - 13:33:22 CST