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
can we give one check for all vendors in automatic payment run? how?
What is sap market place?
How do you create an instance?
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?
Explain what is sap ides?
What is the procedure to applying patches?
Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance
What are common background jobs that will run in your system?
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
What is an interface in SAP?
In my portal ABAP + JAVA I get a bootstrap error message how do I resolve this erroe
How to perform a sap-export and import tables in sap from os level?
What do you understand by executing background jobs in sap system?
What are the different user types in sap system that an admin can use while creating a new user?
What is an “ok” code is and what is the difference between “t-code” and “ok” code?