Hi,
How can I retrieve a dropped user along with data ?
I have dropped a user yesterday at 3:00 pm. I have Hot Backup on 17th DEC. I don't have any export file .
an immediate reply is requested.
prasadvd@rediffmail.com
Printable View
Hi,
How can I retrieve a dropped user along with data ?
I have dropped a user yesterday at 3:00 pm. I have Hot Backup on 17th DEC. I don't have any export file .
an immediate reply is requested.
prasadvd@rediffmail.com
restore backup and apply archived logs till yesterday but of course you will lose evrything from yesterday to today
or
restore backup in another server apply archived logs till yesterday and export the user and import to database
Hi,
Can u give the steps clearly if u don't mind..
Thanx.
I mind, because its explained in much details than I can do in Oracle docs
http://download-west.oracle.com/docs...a76993/toc.htm