GeekInterview.com
Series: Subject: Topic:
Question: 9 of 89

How to recover the datafile without having backup?

Take cold backup and recover
Asked by: Interview Candidate | Asked on: Aug 18th, 2011
Showing Answers 1 - 2 of 2 Answers
naveen

Answered On : Sep 19th, 2011

alter database create datafile 'and give the datafile location and /name' by using this command we can recover the datafile without backup also

  
Login to rate this answer.
shoaib1786

Answered On : Nov 5th, 2011

View all answers by shoaib1786

just create the datafile with same location mention in ur controlfile and recover the datafile ... Its simple.

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Answered Questions

Related Open Questions

User Panel

Register
Login
Lost Password
Get Activation Code

Categories

Btrieve

Clipper

Database Admin

Firebird

Informix

Microsoft Access

MYSQL

PostgreSQL

Progress

SAP DB

SQL

SQL Server

Stored Procedures

Sybase

Teradata

Unify

Interview Coaching

How do you approach a problem?

Importance of an MBA for an entrepreneur

How to Overcome Employment Gap during interview.

Provide an example of a goal that you successfully attained.

How to handle academic gap while applying for a job?

Career Options for BCA Graduates

BPO Career for BTech Graduates

What are the things you wish to achieve in 5 years?

What do you do when things do not go as planned? Cite an example.

How do you deal and overcome major challenges?

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.

Subscribe