Alter tablespace problems

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) Received on Sat Mar 04 1995 - 00:47:55 CET