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


Please Help Members By Posting Answers For Below Questions

Explain kernel upgrade?

613


Explain how client refresh is different than client copy?

620


can anyone tellme java instance startup sequence?

9100


I need to change the Company address parameters of a user. The path is SU01 -> -> Change - > Address Tab - > Display Icon in Company Address section. In the new screen, i see a preview section icon; on clicking which, I can change the parameters such as "Sending Country"; "Street/PO Box number" and number of lines in the resulting pop up. Here though i change the parameter "Street/PO Box number" field to 'S' ( Street has priority over PO Box), its changing again to 'P' (PO Box has priority over street) only. In the help section it is written that if we set the user parameter (tcode SU3) LND1 to the desired country we can control the user specific Sending Country with the desired value else it takes the Sending Country of the Company defined by default. But no such parameter has been given for Street/PO Box number so that we could change its value atleast there. Someone suggest me how to change the Street/PO Box number of the Address format for a user to the desired value.

4404


Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?

649






The transaction should not be displayed in User Easy access menu. How to do user auditing in sap? What will u audit?

1970


Which are the most frequent errors encountered while dealing with transports ?

759


What is the procedure to applying patches?

641


what is the difference b/w 4.7EE & ECC5.0?

1949


How can you find the list of objects that have been repaired in the system?

720


What is development class? Why to create the development class?

602


what are the main issues you faced in the implementation project?

1535


Mention what is the purpose of table usr02?

646


What is the folder it will ask to install oracle?

759


What is the different type of users in sap?

665