Re: is there any oracle package to convert between ASSM and manual

On Apr 8, 2005 3:23 PM, Guang Mei <GMei@xxxxxx> wrote:
> Say in oracle 9i, if I do
> create tablespace A datafile '/oracle/oradata/sales/a01.dbf' size 20m
> extent management local segment space management manual;
> 
> create tablespace B datafile '/oracle/oradata/sales/b01.dbf' size 20m
> extent management local segment space management auto;
> 
> Is there an oracle supplied package that can convert tablesapce A to
> "segment space management auto",  and tablesapce B to "segment space
> management manual", assuming I already have data in both tablespaces?
> The reason is that we have some sql scripts that were written before ASSM
> was availble and they are generating errors now when tablspace is in ASSM.
> I am curious if the tablespace was "converted" from manual to ASSM somehow
> while the DB was running.


no there is no way to convert to ASSM with creating a new tablespace
--
http://www.freelists.org/webpage/oracle-l

Other related posts: