Home » RDBMS Server » Server Administration » how to get dropped file
how to get dropped file [message #59570] Thu, 04 December 2003 04:32
dilip kumar
Messages: 111
Registered: December 2003
Senior Member
hi sam i think ur problem has been solved

there is alternative solution for this

if ur database is running in archive log mode and if u have not taken a backup of that file then do the following operation

execute the command

ALTER DATABASE CREATE DATAFILE 'NAME AND LOCATION OF DATAFILE' AS 'NAME AND LOCATION OF DATAFILE'

THEN RECOVER IN USUAL MANNER

Report message to a moderator

Previous Topic: how to fix internal error code -600 at database level
Next Topic: Urgent CLOB
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 08:20:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.