On Apr 8, 2005 3:23 PM, Guang Mei <GMei_at_ph.com> 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
Received on Fri Apr 08 2005 - 12:15:13 CDT
