Howard J. Rogers wrote:
> "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
Thanks.
--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Fri Mar 12 2004 - 16:56:24 CST
