Oracle Data Wizard online help
Prev | Return to chapter overview | Next |
Customizing common dump options
Use multi-row INSERT statements/Use separate single-row statements
Use these options to define type of INSERT statements to be generated. To create a smaller dump file and speed up inserts when the file is reloaded, select the multi-row inserts and specify the commits' frequency.
Statement syntax
This allows you to specify the SQL syntax the result script to be written on. This feature allows you to restore the dump contents to a table in a different database server such as MySQL, PostgreSQL, SQL Server, Oracle, Firebird, or SQLite.
Add the "Create table" statement to the top of the dump
By default the dump file contains only INSERT statements. To include the SQL definition of the source table, check the corresponding box.
Output
Specify the output directory for the result files and the files encoding.
Prev | Return to chapter overview | Next |