Re: TSPITR and one table per tablespace

This sounds like it might be a good idea you might run into OS limits on files and such things. You can do a single table recovery using a cloned database which would be easier to manage.

Ruth
----- Original Message -----
From: <Kapil.Mathur_at_wachovia.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, May 11, 2000 3:27 PM
Subject: TSPITR and one table per tablespace

> 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 - 06:46:10 CDT