Re: 9.2 32-bit to 10.2 64-bit Migration

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 14 Jul 2006 22:24:36 +0200
Message-ID: <eavfb290pt7iqkgr8uk1m6ge9ok3e6u2l0@4ax.com>

On 14 Jul 2006 04:16:04 -0700, "Charles Hooper" <hooperc2000_at_yahoo.com> wrote:

>* Pre-create the tablespaces to reduce the time that it takes to
>perform the import, and to reduce fragmentation at the operating system
>level - if you know that you will need a 25GB data file for a
>tablespace, create the data file at that size before the import.

As a datafile in many cases is the smallest unit of recovery, anything beyond 2 Gb is IMO undesirable, and 25 Gb is just asking for trouble.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jul 14 2006 - 15:24:36 CDT