Re: Tables per Tablespace

Tablespaces can have multiple data files, but can you specify into which file to place a table?????????

Tony Walby <tony.walby_at_bridgewatersystems.com> wrote in message news:3A2FAFA7.45BB4DB8_at_bridgewatersystems.com...
> 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 - 19:24:35 CST