How to make a Data Backup in oracle ? What is the procedure
for creating the dump files in oracle ( any version ) ?
- 3 Answers
- 6206 Views
- Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / ace dba
A dump is _NOT_ a backup. You cannot roll forward to a
point in time after the dump was taken. The dump is for
moving data from one environment to another, and etc. Using
dump for backup _WILL_ result in data loss.
| Is This Answer Correct ? | 0 Yes | 0 No |
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
how to use sequence and what use of sequence cache
What is the implicit cursor in oracle?
What is an oracle user account?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What do you understand by a database object? Can you list a few of them?
what is the difference between simple view and complex view?
How to transfer database(500 gb) of oracle enterprise edition to standard edition downtime is only 1 hour not using exp/imp option ?
Give the advantages and disadvantages of clusters.
Explain the relationship among Database, Tablespace and Data file?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the most common interview questions on ETL Testing for experience?
Oracle General 
