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 |
How to write an inner join with the where clause in oracle?
What are the uses of linked server and explain it in detail?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
Explain the different normalization forms?
How can we find out the current date and time in oracle?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
What are named parameters?
Is primary key indexed by default in oracle?
What do you mean by group by clause?
How to apply filtering criteria at group level in oracle?
What is the difference between SQL and SQL Server?
How to execute a stored procedure in oracle?