Re: Tablespace to auto management from manual
- From: BobMetelsky <bobmetelsky@xxxxxxxxxxx>
- Date: Mon, 22 Aug 2005 00:04:08 -0400
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/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
