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 system global area (sga) in oracle?
How to install oracle database 10g xe?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
What is the difference between Outer join and Full outer join?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
Can a primary key contain more than one columns?
What are the different types of partitions in oracle?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
How does oracle handle read consistency?
What is an oracle user role?
What are the types of Database Links ?