How can we create the complete backup of data in the oracle.
- 1 Answers
- 2241 Views
- Satyam, IPEC, SunTec, I also Faced
- E-Mail Answers
Answer / 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 |
How can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
Please explain drop constraint oracle?
Whether any commands are used for months calculation? If so, what are they?
master table and child table performances and comparisons in Oracle ?
What is the data pump import utility?
How to select some rows from a table in oracle?
What are the ansi data types supported in oracle?
Which environment variables are absolutely critical in order to run the OUI?
How to create a table interactively?
How to view the data files in the current database?
How to estimate disk space needed for an export job?
Explain the use of inctype option in exp command.
Oracle General 
