Interested to Buy Any Domain ? << Click Here >> for more details...
how to take database backup in oracle ?
how to crate a table space in oracle database ?
- 2 Answers
- 6832 Views
- I also Faced
- E-Mail Answers
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 difference b/w 4.7EE & ECC5.0?
Differentiate between synchronous and asynchronous transport
How you can assign an object to 100 roles at time?
What is sap ides?
Explain what is the importance of table t000?
How will u send mail after completion of backup?
What are the key responsibilities of sap basis administrator?
What is the folder it will ask to install oracle?
How will go about doing a client copy ?
What is the use of Trusted system? I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system?
how can we set a/r a/p netting for inter company code transactions? is it possible to do? if yes, give the solution?
Transport request types and its syntax?
What is JVM switch. Why JVM switch is required ?
How do you create an instance?
What is luw (logical unit of work)?
