Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: separate tablespaces for tables and indexes

RE: separate tablespaces for tables and indexes

From: Stephen Lee <Stephen.Lee_at_DTAG.Com>
Date: Mon, 13 Dec 2004 13:16:44 -0600
Message-ID: <F5340B0E4DA1B64E906D328077060B21053599B3@dtagpo2.dtg.local>

Maybe not a "need". If your database is a big one, there might be some practical administration value in busting things up into smaller chunks. While it is possible to have all your data in a 5 terabyte tablespace, I don't think it is considered to be a best practice.

>-----Original Message-----
>Since the tablespaces are locally managed, is there a need to separate
>the tables and indexes anymore?

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Dec 13 2004 - 13:13:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US