Re: Tablespace and tables question

Normally you create a tablespace for many tables. In your case, you can create 2 tablespaces and create the static tables is one and the dynamic tables in the other.

Another good tip is to create a tablespace exclusively for indexes. This is best put on a different drive fro the tables.

Roy Klassen rklassen_at_pei.sympatico.ca

David Kilbern <davidk_at_navo.hpc.mil> wrote in article <33D7B783.237C_at_navo.hpc.mil>...
> What is the best solution in creating tablespaces/tables?
>
> 1 tablespace for each table
> 1 tablespace and multiple tables
> multiple tablespaces with multiple tables in each
>
> What are the advantages/disadvantages?
>
> I have about 10 to 15 tables to create with 2/3's of
> the tables remaining static once the data is ingested.
> Appreciate any information/experiences.
>
>
> david
> --
> ---------------------------------------------------------------
> David Kilbern "I believe an intelligent being
> davidk_at_navo.hpc.mil governs everywhere, except for
> Database Analyst/DBA certain parts of New Jersey."
> Northrup Grumman
> Stennis Space Center, MS - Woody Allen (Sleeper)
> ---------------------------------------------------------------
>
Received on Sat Jul 26 1997 - 00:00:00 CDT