Re: is there any oracle package to convert between ASSM and manual
- From: David Sharples <davidsharples@xxxxxxxxx>
- To: "Oracle-L (E-mail)" <Oracle-L@xxxxxxxxxxxxx>
- Date: Fri, 8 Apr 2005 17:09:39 +0100
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
