Re: Alter tablespace problems

From: <michel.lalonde_at_sit.ulaval.ca>
Date: Mon, 6 Mar 1995 23:46:17 GMT
Message-ID: <michel.lalonde.4.0012C614_at_sit.ulaval.ca>


In article <3j89rc$sbe_at_nntp.interaccess.com> dzuzga_at_interaccess (David E. Zuzga) writes:
>From: dzuzga_at_interaccess (David E. Zuzga)
>Subject: Alter tablespace problems
>Date: 3 Mar 1995 23:47:55 GMT
 

>I am having a problem with sizing database files. Here's the story:
 

>1. I did an
> ALTER TABLESPACE T1 ADD DATAFILE '/dev/rdsk/c2t2d0s3' size 984M;
 

>2. Unfortunately, this was the wrong size, it should be 1735M.
 

>How can I change this? Can I drop these files from the tablespace
>without dropping the tablespace itself? I've tried taking the datafiles
>offline and recreating them with the ALTER DATABASE CREATE DATAFILE
>'/dev/rdsk/c2t2d0s3' as '/dev/rdsk/c2t2d0s3' size 1735M, but that didn't
>increase the size (it stayed at 984M).
 

>HELP!
 
>Dave Zuzga (dzuzga_at_interaccess.com)

Wy not just create an other datafile '/dev..../c2t2d0s4' on the same tablespace with the difference in space.

Michel Lalonde :-) Received on Tue Mar 07 1995 - 00:46:17 CET

Original text of this message