Re: File exists error message with REUSE option

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 4 Sep 2005 17:21:27 +0100
Message-ID: <bf463805090409216b6ad132@mail.gmail.com>

On 9/4/05, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:
>
> If you specify SIZE 50M, the existing file MUST be 50M in size.

That may be version/platform dependent, as it worked fine with 9.2.0.6 on Linux : check the docs.

1* create temporary tablespace temptest tempfile '/u01/oradata/dv03/temptest01.dbf' size 10m 09:19:01 SQL> / Tablespace created.

>From shell:

0:1-::oracle-/dev/pts/20 > touch temptest02.dbf

SQL> alter tablespace temptest add tempfile '/u01/oradata/dv03/temptest02.dbf' size 10m reuse;

Tablespace altered.

>From shell:

:oracle-/dev/pts/20 > ls -l temptest02.dbf -rw-r--r-- 1 oracle dba 10493952 Sep 4 09:20 temptest02.dbf

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l

Received on Sun Sep 04 2005 - 11:23:27 CDT