Interested to Buy Any Domain ? << Click Here >> for more details...
How to make a Data Backup in oracle ? What is the procedure
for creating the dump files in oracle ( any version ) ?
- 3 Answers
- 7040 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 |
How many file formats are supported to export data?
Explain the difference between a procedure and a function? What do you understand by those terms?
How do we switch from init.ora file to asp file?
What happens if variable names collide with table/column names?
How to define a specific record type?
How can we view last record added to a table?
What is the usage of synonyms?
What is a deadlock in SQL? How can you prevent it?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
what is the difference between data migration and production migration.
How to build data dictionary view an new database?
Describe an oracle table?
Oracle General 
