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
What are the different ways you can create databases in sql server? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
how can you connect from 10g user to 11g user??
what is the use of ocr?
what do you understand by fine-grained auditing?
what functionality does oracle provide to secure sensitive information?
What are the operating modes in which database mirroring runs? : sql server DBA
how can you schedule a job in database?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
what is a crs resource?
What is the default fill factor value? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?