How can we create the complete backup of data in the oracle.
- 1 Answers
- 2240 Views
- IPEC, Satyam, SunTec, I also Faced
- E-Mail Answers
Answer Posted / Daya Shankar Kumar
To create a complete backup of data in an Oracle database, you can use the following steps:
1. Connect to the Oracle database as a user with appropriate privileges.
2. Run the following command to create a backup file (replace 'backup_file' with your desired filename):n ```sqln EXP DBA/PASSWORD FILE='backup_file.dmp' FULL=YES; n ```
3. Verify that the backup was created successfully by checking the backup file.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to start an oracle instance?
How to write a left outer join with the where clause in oracle?
How to put more than 1000 values into an oracle in clause?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to use values from other tables in update statements using oracle?
What is oracle latest version?
Design database draw er diagram for a certain scenario ?
How to select all columns of all rows from a table in oracle?
