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 Hash Index?
What is clustered table in Oracle?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
What are the different types of modules in oracle forms?
what are Triggers?
What is a cursor variable?
What is the difference between an Oracle Schema and an Oracle Instance?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
Explain the use of compress option in exp command.
what is Materialized view? What is a snapshot? what are the similarities and differences between Materialized views and snapshots?
What are the ways tablespaces can be managed and how do they differ?