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

Home -> Community -> Usenet -> c.d.o.server -> restructing tables in new tablespaces - advice

restructing tables in new tablespaces - advice

From: Steven <SPAMBLOCKER_at_gmx.net>
Date: Mon, 11 Aug 2003 18:08:06 +0200
Message-ID: <bh8f0u$v69sf$1@ID-82797.news.uni-berlin.de>


Hi,

I have to restructure the tables in our database and am wondering the best way to structure the tables. Current the tables are ordered by application in separate tablespaces. But I now want to use UNIFORM tablespaces. Thus I am wondering if I should separate the tables by size as some tables are 1-2 MB and other 80-300MB. does it make sense or not worth the effort??

Does anyone have any advice on this??

Thanks,
Steve.

-- 
-----------------------------------------------------------------
Holidays in Berchtesgaden, Germany:
http://www.sonnenkoepfl.de
http://unterkunft-berchtesgaden.de
http://pension-berchtesgaden.de
Received on Mon Aug 11 2003 - 11:08:06 CDT

Original text of this message

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