How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.
Answer Posted / nehru
>alter database create datafile 'old path' as 'new path' size
>recover datafile 'datafile id';
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
when does an alert gets signaled?
which background process invoke at the time of upgradation tell me???
How to start SQL Server in minimal configuration mode?
What happens on checkpoint? : sql server DBA
what do you understand by flashback feature of oracle?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What is replication? : sql server DBA
How do you open a cluster administrator? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What types of replication are supported in sql server? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What are the different types of indexes available in sql server? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
internal architecture
suppose you want to audit specific activities on sensitive data. How can you achieve that?