Re: Migrate to locally managed tablespaces

From: Mark D Powell <mark.powell_at_eds.com>
Date: 19 Apr 2002 11:55:13 -0700
Message-ID: <178d2795.0204191055.5850e24b@posting.google.com>

norwoodthree_at_my-deja.com (NorwoodThree) wrote in message news:<ba03e2c.0204180903.13cd1659_at_posting.google.com>...
> The Apps tablespaces are already locally managed by default. This is
> a worthless exercise.

Norwood, your statement may be true for a fresh installation on 8.1+ but would probably not be true for sites that had upgraded in place from earlier generations of the application/database though it is possible to convert dictionary managed tablespaces to locally managed tablespace in place using execute
sys.dbms_space_admin.tablespace_migrate_to_local the free space distribution that results is less the optimal after the conversion so I can see that reloading could be beneficial in some cases.

IMHO -- Mark D Powell -- Received on Fri Apr 19 2002 - 13:55:13 CDT