On Thursday 19 July 2001 10:56, Kimberly Smith wrote:
> Actually, I discovered that you cannot use it for the rollback tablespace
> either. Oh, you can create the tablespace no problem but then you cannot
> create the rollback segments in it. Something that the doco failed to
> mention.
Kimberly,
Maybe it's a version/platform dependent bug?
10:51:26 jkstill@ts01 SQL> create tablespace RBS2 datafile
10:51:36 2 '/u01/oradata/ts01/ts01_rbs02.dbf' size 20m
10:51:48 3 extent management local uniform size 1m
10:52:09 4 /
Tablespace created.
10:52:17 jkstill@ts01 SQL> create rollback segment rbl01 tablespace rbs2;
Rollback segment created.
10:52:32 jkstill@ts01 SQL> alter rollback segment rbl01 online;
Rollback segment altered.
10:54:27 jkstill@ts01 SQL> create table test2 ( td date );
Table created.
10:55:39 jkstill@ts01 SQL> set transaction use rollback segment rbl01;
Transaction set.
10:56:42 jkstill@ts01 SQL> insert into test2 (td) values(sysdate);
1 row created.
10:56:57 jkstill@ts01 SQL> commit;
Commit complete.
10:56:58 jkstill@ts01 SQL>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jared Still
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).