RE: Locally managed tablespaces...SOLVED!!

Sorry I missed the original post! Must have been near all those off-topic ones... ;)

In order to create your RBS TS as locally managed, create a small RBS in a dictionary managed TS (I used SYSTEM -- I know, I know...) and put it online. Create the RBS TS as locally managed, add your RBSs to it, then offline/remove the original RBS that was created in a dictionary managed TS.

HTH!

Rich Jesse                          System/Database Administrator
Rich.Jesse_at_qtiworld.com             Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Rocky Welch [mailto:rockyw_99_at_yahoo.com]
> Sent: Friday, December 01, 2000 12:01
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Locally managed tablespaces...SOLVED!!
>
>
> The tablespace cannot be changed from Data Dictionary to
> Locally Managed
> after it's been created (according to some documentation I found). The
> tablespace must be created that way from the begining:
>
> CREATE TABLESPACE JUNK
> DATAFILE '/BLAH/BLAH/BLAH.DBF' SIZE 100M EXTENT MANAGEMENT LOCAL
> ONLINE PERMANENT;
>
> It also appears that the rollback tablespace MAY NOT be
> locally managed.
> After creating it as such it would not let me create rollbacks in the
> tablespace until I recreated it as data dictionary managed.
>
> Thanks to all who replied,
>
> -Rocky

This message has been scanned for viruses with Trend Micro's Interscan VirusWall. Received on Fri Dec 01 2000 - 12:33:08 CST