Re: Alter tablespace problems

In article <michel.lalonde.4.0012C614_at_sit.ulaval.ca> michel.lalonde_at_sit.ulaval.ca writes:
> In article <3j89rc$sbe_at_nntp.interaccess.com> dzuzga_at_interaccess (David E. Zuzga) writes:
> >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).
>
> Wy not just create an other datafile '/dev..../c2t2d0s4' on the same
> tablespace with the difference in space.

It sounds like the original poster is using raw partitions, and I don't know (think) you can have multiple datafiles per raw partition.

Back to the original question, you need to take the datafiles offline, drop the tablespace, and then recreate the tablespace with the right size. You didn't mention whether you've dropped the tablespace, so I can't tell if it's a case of lazy typing or an actual missing step.

--
"And this is all I have to say about that..."   - F. Gump
      ___
     (o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
|  Alvin W. Law ..... Oracle Corporation ....... Email: alaw_at_us.oracle.com  |
+---------------------------------------------------------------------------+

ORA-03113: end-of-file on communication channel