RE: Manty tablepsaces in a small database

From: Javier Morales <Javier_at_infojobs.net>
Date: Mon, 23 Oct 2000 15:55:30 +0200
Message-Id: <10658.119966@fatcity.com>

so, maybe you don't need much tablespaces...

... I mean, The reading of a table using a index, if it's separate in another tablespace and you use several mount points, then there can be a increase in the results' speed. That's clear, but if you only have one mount point... who knows!... maybe you need someday to set up free space and you can drop a entire tablespace.

;-)
(a bored dba, too...)

-----Mensaje original-----
De: paquette stephane [mailto:stephane_paquette_at_yahoo.com] Enviado el: lunes 23 de octubre de 2000 15:01 Para: Multiple recipients of list ORACLE-L Asunto: Manty tablepsaces in a small database

Hi,

I've been caught in this small database project. My question is do you create many tablespaces to separate tables, indexes, the different repositories stored in the db,... For now, there is more trouble than any gain.

For example, this a dss system with fact and dimension tables. Usually the fact tables are huge and have their own tablespaces or each partition has its own tablespace. This time, I can put everything in 1 tablespace.
Also, since it's small, I do not have many independant mount points so what is the gain of using many tablepsaces ?

A bored dba
TIA

Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE. http://im.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-1?q?paquette=20stephane?=
  INET: stephane_paquette_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Mon Oct 23 2000 - 08:55:30 CDT