Re:TSPITR and one table per tablespace

From: <dgoulet_at_vicr.com>
Date: Fri, 12 May 2000 09:03:05 -0400
Message-Id: <10495.105493@fatcity.com>

Kapil,

    I'm sure that some of the list members will disagree with me, but that is one of the most Dilbert ideas I've heard since the VARCHAR2(255) idea. Assuming you implement such an idea, consider that each tablespace MUST consist of at least one file and that files CANNOT be shared across tablespaces. That means that you need one data file for each table. Now the question becomes, how many tables do you have and how many files will the OS let you have open at one time?? The former will be larger that the latter in a short time. Personally I like isolating one application to one tablespace as a minimum. That way, if I have to recover a tablespace then at least that application should be consistent when I'm done. Consider our PeopleSoft application with more than 2000 tables???

Sheesh, what did you buy? A sophisticated RDBMS or a very expensive file manager??

Dick Goulet
Senior Oracle DBA
Vicor Corporation

____________________Reply Separator____________________

Subject: TSPITR and one table per tablespace Author: Kapil.Mathur_at_wachovia.com
Date: 5/11/00 11:27 AM

hi,

     someone mentioned to me that since Oracle8 has Tablespace-point-in-time recovery capabilities, it makes for a valid argument to put each table in it's own tablespace - the implication being that if a tablespace contains only one table, recovering a tablespace and recovering the table are identical - since I am not that familiar with the pros and cons of TSPITR , I was wondering if that feature is any reason to isolate every table in it's own tablespace - Certainly, the capability to recover data at a table by table basis makes it easier to "undo" end-user ad-hoc DML errors but I don't know what the possible overheads of such an approach might be - Any ideas, suggestions ....

thanks
Kapil

-- 
Author: 
  INET: Kapil.Mathur_at_wachovia.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 Fri May 12 2000 - 08:03:05 CDT