How to make a Data Backup in oracle ? What is the procedure
for creating the dump files in oracle ( any version ) ?
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 |
What is a trace file and how is it created in oracle?
what are Triggers?
What are Schema Objects ?
Does a Before form trigger fire when the parameter form is suppressed ?
Name the various constraints used in oracle?
What is an oracle tablespace?
Does oracle partitioning improve performance?
what is the output of select * from emp where null=null & select * from emp where 1=1
How can we Update a table with out using UPDATE command?
How to empty your oracle recycle bin?
What is the database name in oracle?
What are the different types of databases?