I have never worked on a mainframe so I can't comment on whether a tablespace can be resized or not
In UNIX or NT a datafile can be resized by using the ALTER DATABASE DATAFILE ...... command
It is better in some respects to have fewer datafiles, depending upon the usage of your system
Cheers




Reply With Quote