Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> is there any oracle package to convert between ASSM and manual
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.
Thanks.
Guang
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Apr 08 2005 - 10:27:30 CDT
![]() |
![]() |