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

From: Frank <fbortel_at_nescape.net>
Date: Sat, 13 Dec 2003 17:03:00 +0100
Message-ID: <brfcmu$72$1@news4.tilbu1.nb.home.nl>

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

Reuse will prevent an error like 'cannot create file - file already exists', as the manual would have explained. It will reuse an existing file, or create if it isn't there

-- 
Regards, Frank van Bortel

Received on Sat Dec 13 2003 - 10:03:00 CST