Re: Recovering a user

Sathya wrote:
> Hi,
>
> I want to know whether we can restore a user from cold backup. I will
> put my question this way. I have 2 DBs. DB1 has user1. I have taken
> coldbackup of DB1. I want to create that user in DB2 from coldbackup
> without affecting other things in DB2.
> It is really urgent. Your timely help is greatly appreciated.
>
> Regards,
> Sathya
>

One option is to restore the cold backup to another database server. Then use export to create a dump file containing just the user in question. Take the dump file to your main database server and import its contents there.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown