Re: Transporting Dictionary Managed Tablespace to 10g

From: <thtsang_yh_at_yahoo.com.hk>
Date: 22 Jul 2006 05:02:51 -0700
Message-ID: <1153569771.519046.38790@s13g2000cwa.googlegroups.com>

joel garry wrote:

>
> How much data is it? Can you just use regular exp/imp?
>
> jg

This is one key point. There are 70GB data, and 65GB belong to the a single LOBSEGMENT & its corresponding LOBINDEX. Therefore I want to avoid copying the data around Any know how much time will it take to export such amount? And if the import failed midway, do I need to drop everything and start over again?

Also, is conversion of Dictionary Managed Tablespace to Locally reliable on oracle 8i? Would it copy data around (slow) or just create some data structure (fast)? Received on Sat Jul 22 2006 - 07:02:51 CDT