Re: Locally managed tablespaces

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_at_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_at_ts01 SQL> create rollback segment rbl01 tablespace rbs2;

Rollback segment created.

10:52:32 jkstill_at_ts01 SQL> alter rollback segment rbl01 online;

Rollback segment altered.

10:54:27 jkstill_at_ts01 SQL> create table test2 ( td date );  

Table created.  

10:55:39 jkstill_at_ts01 SQL> set transaction use rollback segment rbl01;  

Transaction set.  

10:56:42 jkstill_at_ts01 SQL> insert into test2 (td) values(sysdate);  

1 row created.  

10:56:57 jkstill_at_ts01 SQL> commit;  

Commit complete.  

10:56:58 jkstill_at_ts01 SQL>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).