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 the procedure for java stack upgradation?
How to configure TMS?
What is upgrade process? And how u will do that?
What are the different types of rfc and explain what transactional rfc is?
At o.s level where to check for system logs of sap application?
hi friends, in sap screen with 000 client i unable to logon,with 001 client i can login but i want to log on with 000 client how i can loggin with 000 client intial screen ,please can u help me
What is transport domain?
How to transfer request which is created directly on quality server & has to be moved to in production server?
What are steps for DB Refresh?
If you have a long-running Job, how do you analyse?
A transport is imported into QAS in 2 min. time the same transport when imported into PRD is taking more than 20 min. why? What to do?
What is the system's configuration required to implement SAP.
What is private mode? When does user switch to user mode?
How you will do that?
Explain the architecture of sap system with different layers. What is the use of gateway?