Re: Tables per Tablespace

Are you aware that a tablespace can have multiple datafiles. I do not believe there is a limit on the number of table sin a tablespace. Actually it is recommended that you keep all you app tables in one tablespace, separate you indexes into a separate tablespace of course and you could also separate you add-on appdata to another tablespace.

Generally you should keep your datafile under 2G (Could run into Oracles 2G limitation on some platforms and versions).

Here is what I do.

Tablespaces                            Datafiles
system                                     system01.dbf
temp                                        temp01.dbf
usr                                           usr01.dbf
rollback                                    rollback01.dbf
                                                rollback02.dbf
rbs_big                                     rbs_big01.dbf
app_[appname]_data                app_[appname]_data01.dbf
                                               app_[appname]_data02.dbf
app_[appname]_index              app_[appname]_index01.dbf
                                               app_[appname]_index02.dbf
tools                                        tools01.dbf
misc                                        misc01.dbf

Should be self explanatory.

bcarignan_at_my-deja.com wrote:

> Is there a standard for determining the number of tables that should
> exist in a tablespace? If I can fit all of the tables for an
> application in a single tablespace, which is composed of a single
> datafile are there any performance ramifications? Other than the case
> of very large (>1 GB) tables, when would it make sense to separate
> tables that logically belong together into separate tablespaces?
>
> Brian
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 07 2000 - 09:41:28 CST