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 |
Display the number value in Words?
Explain what are the uses of rollback segment?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
What is the difference between online and offline backups?
what is the difference between functional dependecy and multilevel dependency?
how to see the data (in unix) using dataset in datastage?
What is oracle database 10g express edition?
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
How do I know if oracle client is installed on windows?
How to use values from other tables in update statements using oracle?
What is the sid in oracle?
What are the different types of record groups in oracle? Explain each of them