Of course if you look at what you're actually doing
with TSPITR, you're cloning all or a subset of the db
to recover the table(s). TSPITR does allow you to
autotmate, via RMAN, the steps as well as make it
easier to clone subsets of the db. With 8i you can
also integrate it with transportable tablespaces.
Just my 2 cents!
- Anita
- Ruth Gramolini <rgramolini_at_tax.state.vt.us> wrote:
> 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 -----
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> Sent: Thursday, May 11, 2000 3:27 PM
>
>
> > 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).
> >
>
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> 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).
Do You Yahoo!?
Received on Fri May 12 2000 - 09:55:51 CDT
