Re: Tablespace to auto management from manual

One (what I would use)

create tablespace xxxLMT datafile '/u01/oradata/some.dbf' size 100M extent management local;
then
  alter table ... move tablespace xxxLMT ;

bob

"Oracle error messages being what they are, do not highlight the correct cause of fault, but will identify some other error located close to where the real fault lies."

J. Dex wrote:
> In a 9206 database on Linux RHEL3, is it possible to change a tablepace
> to auto management if it has already been created with manual
> management? What are the possible ways to change this?
>
> Thanks.
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's
> FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l