Interested to Buy Any Domain ? << Click Here >> for more details...
How do you recover a datafile that has not been physically
been backed up since its creation and has been deleted.
Provide syntax example.
- 4 Answers
- 9909 Views
- I also Faced
- E-Mail Answers
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
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
What authentication modes does sql server support? : sql server DBA
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Why would you use sql agent? : sql server DBA
how can you implement fine-grained auditing?
Why would you call update statistics? : sql server DBA
how can you enable flashback feature?
what are the differences of where and if in SAS?
Which autogrowth database setting is good? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
