How to make a Data Backup in oracle ? What is the procedure
for creating the dump files in oracle ( any version ) ?

Answer Posted / s. senthil kumar

exp username/password@databasename file=c:\filename.DMP
full=N log=c:\filename.LOG

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of save points in oracle database?

624


What is a data lock in oracle?

687


Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

1948


What are the different pseudo commands? Explain in general?

657


What is a directory object?

691






How to do a full database export?

728


When do I need to use a semicolon vs a slash in oracle sql?

674


why dont we assign not null constraint as table level constraint.

2345


Explain how you would restore a database using RMAN to Point in Time?

1727


Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1963


How to start a specific oracle instance?

681


IS it possible to built the oracle database without setting the kernal parameters?

1851


How to use null as conditions in oracle?

665


State and explain the different types of data models?

610


What are the differences between date and timestamp in oracle?

653