Re: File exists error message with REUSE option

From: Jared Still <jkstill@xxxxxxxxx>
To: hkchital@xxxxxxxxxxxxxx
Date: Sun, 4 Sep 2005 17:21:27 +0100

On 9/4/05, Hemant K Chitale <hkchital@xxxxxxxxxxxxxx> 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

References:

File exists error message with REUSE option
From: Sami Seerangan

Re: File exists error message with REUSE option
From: Hemant K Chitale

Re: File exists error message with REUSE option

Other related posts: