Creating multiple tables within a tablespace

Greetings,

We have a database with over 150 tables. Some tables may have 2,000,000 rows with record lengths of around 400 bytes. We currently are creating one tablespace per table in an Oracle 7.1 database running on OpenVMS. We are questioning the advantages and disadvantages of logically grouping several tables into larger tablepspaces thus reducing the total number of tablespaces we have to maintain. What are the compelling advantages of having multiple tables per tablespace when most of our tables are of this magnitude.

Kindest Regards,
Jeff Hunter

--

Jeffrey Hunter                     Internet: jhunter_at_isrv.com
Programmer/Analyst                 WWW: www.isrv.com/~jhunter
PO BOX 832                         Voice: (412) 284-7325
Butler, PA 16003-0832              FAX: (412) 789-9601