Download Oracle SQL Developer User's Guide

SQL Developer Preferences
Lower values will cause a successful move operation to take more time; but if a failure
occurs, it is likely that more source records will exist in the Oracle tables and that if the
move operation is resumed, fewer source records will need to be moved. Higher
values will cause a successful move operation to take less time; but if a failure occurs,
it is likely that fewer source records will exist in the Oracle tables and that is the move
operation is resumed, more source records will need to be moved.
Offline: The offline data move options determine the results of files created, such as
when you click Tools, then Migration, then Create Database Capture Scripts.
End of Column Delimiter (offline data moves): String to indicate end of column.
End of Row Delimiter (offline data moves): String to indicate end of row.
Generic Date Mask (offline data moves): Format mask for dates, unless overridden by
user-defined custom preferences.
Generic Timestamp Mask (offline data moves): Format mask for timestamps, unless
overridden by user-defined custom preferences.
User-Defined Custom Preferences by Source Type (offline data moves): Lets you
specify, for one or more source data types, a custom mapping for the function and
format mask. Add one row for each mapping. For example, the following rows specify
the Source Type, Function, and Mask for custom mappings for the Sybase data types
datetime, smalldatetime, and time:
datetime
smalldatetime
time
TO_TIMESTAMP
TO_DATE
TO_TIMESTAMP
mon dd yyyy hh:mi:ss:ff3am
Mon dd yyyy hh:miam
hh:mi:ss:ff3am
Migration: Generation Options
The Generation Options pane contains options that are used when generating .sql
script files for creating migrated database objects in the target schema.
One single file or A file per object: Determines how many files are created and their
relative sizes. Having more files created might be less convenient, but may allow more
flexibility with complex migration scenarios.
Generate Comments: Generates comments in the Oracle SQL statements.
Generate Controlling Script: Generates a "master" script for running all the required
files.
Least Privilege Schema Migration: For migrating schema objects in a converted
model to Oracle, causes CREATE USER, GRANT, and CONNECT statements not to be
generated in the output scripts. You must then ensure that the scripts are run using a
connection with sufficient privileges. You can select this option if the database user
and connection that you want to use to run the scripts already exist, or if you plan to
create them.
Generate Data Move User: For data move operations, creates an additional database
user with extra privileges to perform the operation. It is recommended that you delete
this user after the operation. This option is provided for convenience, and is suggested
unless you want to perform least privilege migrations or unless you want to grant
privileges manually to a user for the data move operations. This option is especially
recommended for multischema migrations, such as when not all tables belong to a
single user.
Generate Failed Objects: Causes objects that failed to be converted to be included in
the generation script, so that you can make any desired changes and then run the
script. If this option is not checked, objects that failed to be converted are not included
in the generation script.
1-98 Oracle SQL Developer User's Guide