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 foreign key?
what are archived logs?
what is the output of select * from emp where null=null & select * from emp where 1=1
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is the difference between a vector and an Array? (Java)
master table and child table performances and comparisons in Oracle ?
What is a OUTER JOIN?
Why does Oracle not permit the use of PCTUSED with indexes?
how many types of index?
What is an Integrity Constrains ?
What are various constraints used in SQL?
What do you understand by database schema and what does it hold?