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
If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?
Where do you download trail version of sap ecc, what is sap cal?
Explain domain controller?
How to perform the transport?
How do you check the installed software components and product versions on sap system?
How to perform a sap-export and import tables in sap from os level?
What is JVM switch. Why JVM switch is required ?
How to apply java stacks ? expalin step by step prcoess
What is the importance of table t000?
how can i change access to a user who is having access for SPRO display only to change access in sPro
what is netweaver
Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
what is sox and sod in sap ?
Can any one tell me , what is the role of SAP Security Admin in BW Security and APO Security ?
How you will give new authorizations?