Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Migrating to from dictionary to Locally managed tablespaces

Migrating to from dictionary to Locally managed tablespaces

From: Vincento Harris <wumutek_at_yahoo.com>
Date: 2 Oct 2003 10:13:29 -0700
Message-ID: <2fa13ee7.0310020913.77620a82@posting.google.com>


I am trying to migrate from dictionary managed to locally managed tablespaces.
 to be able to use uniform extents using IMP/EXP .

1)Any drawbacks.....

My understanding is that

1)The initial and next extents which I am trying to change will not be changed.
as the imp will define initial and next as they existed in last table.

Is there a better way to do this, I have a couple of thousand tables and about 70 tablespaces supplied with APP. Oracle 8.1.7.4 HP Unix 9000

Vince Received on Thu Oct 02 2003 - 12:13:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US