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

Explain self joins in oracle?

564


State any two functions of oracle?

636


How to find the duplicate rows count from employees table in oracle?

554


What is the difference between a primary key & a unique key?

590


How to use windows user to connect to the server?

536






Explain enable novalidate constraint.

597


Please explain oracle data types with examples?

590


How many types of auditing in Oracle?

566


Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

612


What is oracle update statement with inner join ?

585


Can we store pictures in the database and if so, how it can be done?

593


Explain oracle left join with an example?

588


How to get a create statement for an existing table?

572


What is a read only transaction in oracle?

596


Give the different types of rollback segments.

581