RE: Locally managed tablespaces

Guess I really have to learn to write in full sentences, which will be hard since I don't even talk that way. Its the autoallocate you can't use. I created it just fine with the uniform size.

Sorry for the confusion everyone.

-----Original Message-----
Sent: Thursday, July 19, 2001 10:59 AM
To: ORACLE-L_at_fatcity.com; Kimberly Smith

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: Kimberly Smith
  INET: kimberly.smith_at_gmd.fujitsu.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).