Home » Other » General » Number of tables in tablespace
Number of tables in tablespace [message #102183] Wed, 20 March 2002 04:41 Go to next message
cece
Messages: 2
Registered: March 2002
Junior Member
How can I determine which is the optimal solution:
One tablespace for many tables or one tablespace for each table?
Re: Number of tables in tablespace [message #102184 is a reply to message #102183] Thu, 21 March 2002 00:24 Go to previous messageGo to next message
Epe
Messages: 99
Registered: March 2002
Member
You should see a tablespace rather as a logical group of tables. I.e. one tablespace for all the tables containing financial data, one tablespace for general data, one tablespace for personnel data...
If you don't have a lot of tables, just put them all in the same tablespace...
Re: Number of tables in tablespace [message #102186 is a reply to message #102183] Thu, 21 March 2002 04:30 Go to previous message
cece
Messages: 2
Registered: March 2002
Junior Member
The problem is that we have grouped the tables according to the team they belong to....the sizing of the tablespaces will be enormous if all the tables are put into one tablespace for each team. That is the reason why we subdivide the tablespaces so that each table has its own tablespace. But I am not sure if this is optimal. The number of tables in each team varies. Some has less than 10 tables, some has 100 tables...
Previous Topic: Need advice(which college is better?)
Next Topic: Re: oracle installaing error on linux
Goto Forum:
  


Current Time: Mon May 23 12:45:03 CDT 2022