Re: Convert TS from dictionary to locally managed

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Thu, 10 Apr 2003 05:39:53 -0500
Message-ID: <v9aiftnajgb6d6@corp.supernews.com>

I have,
I did not have any problems. But for the majority of the tablespaces I have convereted
I have create new LMT's and moved the table/indexes into them them. This way I knew for sure I was starting off clean. Just me opinion though.

Stephen C. Ashmore
Brainbench MVP for Oracle Administration http://www.brainbench.com
Author of: 'So You Want to be an Oracle DBA?'

"Evangelos Giannoulas" <gie_at_pbihag.ch> wrote in message news:1049970085.257241_at_rio.ch.pbihag.ch...
> Hi,
>
> Has anyone tried to convert dictionary managed ts into locally
> using the TABLESPACE_MIGRATE_TO_LOCAL procedure?
>
> Experiences?
> Is it safe to do it on a production system?
>
> Thanks,
> Vangelis
>
>
Received on Thu Apr 10 2003 - 05:39:53 CDT