Re: When Specify 'REUSE' When Creating a Tablespace?

From: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Sun, 14 Dec 2003 10:03:15 +0100
Message-ID: <3l9otvk42o1ncvf21gmu96josrp5us18sc@4ax.com>

On 13 Dec 2003 06:22:20 -0800, basis_consultant_at_hotmail.com (SAP BASIS Consultant) wrote:

>Hello,
>
>I was unable to find much information on this topic. When creating a
>tablespace for an new instance, when would you specify the 'REUSE'
>option? (If it makes any difference, it is Oracle v9.2.0 on AIX v5.2)
>
>
>
>
>
>
>Thanks,
>SAP BASIS Consultant

Claiming disk space from the OS for a datafile make take a while (I've seen minutes for Gigs), with REUSE you use space that is already yours.

Jaap. Received on Sun Dec 14 2003 - 03:03:15 CST