Re: Partial Restore ?

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 Fri Nov 13 1998 - 15:41:41 CST