how to take database backup in oracle ?
how to crate a table space in oracle database ?
Answer Posted / john
dbForge Studio for Oracle provides database backup option:
1. Start Page -> Data Pump -> click Schema Export -> Schema Export Wizard
2. In the Connection list select a connection / click <Manage...> -> New (create a new connection).
3. Select a database you want to backup in the Schema list, once the connection is established.
4. Specify a folder path to store backups in the Path text box.
5. Specify an output file name in the Output file name text box.
6. (Optional) You can setup some optional settings such as: Append timestamp to the file name, Auto delete old files, Use compression (ZIP), etc.
7. Click Next.
8. Select database objects to export -> Next.
9. Specify detailed options on how schema export should be performed -> Next.
10. Select the Write a report to a log file check box to save the backup process information to a log file. Enter the path where to store the file, for instance: C:UsersDocumentsExportSchemaExport.log
11. Click Export.
12. As soon as the export process is finished -> Next -> Save Project.
Backup can be run also from the Command Line. Scheduling is included.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is sap ides?
Where will u find transport error logs?
How you can assign an object to 100 roles at time?
What will you do if u got Update failure?
Explain what is the purpose of tdevc ?
I'm getting the following runtime error in IDES "DYNPRO_MSG_IN_HELP". GUI is 720 final release and patch level:0
How to configure TMS?
How to transfer request which is created directly on quality server & has to be moved to in production server?
How you will get help from OSS notes?
What is purpose user group in SU01?
The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?
Is it possible to install sap patches when other users are online?
What is transport layer and domain controller? In which system you have create domain control?
Which transport directory is used to implement support package and add-ons?
How you will rate yourself in SAP, Oracle from a scale 1 - 10?