Re: Changing to LMT tablespaces

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Fri, 27 Oct 2000 09:02:41 -0400
Message-Id: <10662.120442@fatcity.com>

Hello Diana,

Have you looked at using the TABLESPACE_MIGRATE_TO_LOCAL procedure in the DBMS_SPACE_ADMIN package?

Jonathan

Tuesday, October 24, 2000, 5:55:58 PM, you wrote:

DD> I'm planning on turning my dictionary managed tablespaces into locally
DD> managed tablespaces.  Am I correct in assuming that I'll have to perform the
DD> following steps:

DD> 1) Create new tablespaces
DD> 2) Move tables into the new tablespaces
DD>         a) Since most of my tables are partitioned, I'll actually have to
DD> move each partition, right?

DD> 3) Rebuild indices into the new tablespaces DD> 4) Drop the old tablespaces

DD> Or is there an easier way?

-- 
Best regards,
 Jonathan                            mailto:jonathan_at_gennick.com

Received on Fri Oct 27 2000 - 08:02:41 CDT