DON'T DO IT. I have heard this proc is not yet ready for prime time.
----- Original Message -----
From: Jonathan Gennick <jonathan_at_gennick.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Friday, October 27, 2000 10:11 AM
Subject: Re: Changing to LMT tablespaces
> 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
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jonathan Gennick
> INET: jonathan_at_gennick.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Oct 27 2000 - 13:26:16 CDT
