Re: Partial Restore ?

Wim Teuwens wrote:

> Ok. I know what you mean.
>
> But I'm talking about 15 tables with appox. 600000 rows !
>
> I hope our serversupplier has enough disks to sell me, if i'm importing
> those tables (tablespace, roll-back segments, etc...). And it's possible I
> have to do this a few times per month! Isn't this way of restoring a waste
> of time and space ?
>
> Isn't there no tool to import only those rows from a table which meet a
> specific criteria ? Such as only those rows where ID > 1000 AND LOCATION =
> 'USA' (something like that) ?.

No, Unfortunatly IMport do not use Where clause ..but using proper triggers on that tables may be as solution ...
the back side of that approach is lowering perfomance of insertion ...

>
>
> Thanks anyway. I'll consider your solution.
>
> By the way, I heard someone mentioning 'Snapshots'. Could this maybe be a
> solution ? (I'm quite new with Oracle and am not so sure what he meant with
> that).
>
> Bye
>
> Thomas Pall wrote in message <364ca795.0_at_feed1.realtime.net>...
> >Take a look at fromuser, touser parameters in Import. You could create a
> >new user, give them unlimited tablespace or resource role (which
> >internally grants unlimited tablespace to the user), or enough
> >quota on some tablespaces. You import the objects belonging to the
> >schema you do not want to clobber into the schema of the new user. The
> >system privilege needed to import one user's objects into another schema
> >is Become Any User.
> >
> >Once you have your tables restored into the new schema, issue the
> >appropriate sql to merge the data with the tables already there.
> >
> >Wim Teuwens (wte_at_technum.be) wrote:
> >: Hi,
> >
> >: I'm quite new in the RDBMS/Oracle World, and have a question about
> >: restoring data:
> >
> >: Suppose I want to restore some data from some tables which has been
> back-upd
> >: let's say 1 month ago.
> >
> >: When I do a restore (import), is it not true that I overwrite ALL the
> data
> >: I've entered afther that backup from a month ago ?
> >
> >: So my question is : how can I do a partial restore from a dump ?
> >
> >: Thanks,
> >
> >: Wte_at_Technum.be
> >
> >
> >
> >--
Received on Sun Nov 15 1998 - 12:20:09 CST