|
Ispirer SQLWays Database Migration Software
[Oracle] Subsection
This subsection is used to adjust script generations when Oracle is the target database, and to specify properties when it is the source database.
- BIN - Specifies the directory where the Oracle utilities like SQL Plus and SQL Loader are located.
- SQLLOADER - The name of the executable module of the Oracle SQL Loader. The default value is sqlldr.exe.
- SQLPLUS - The name of the executable module of the Oracle SQL Plus. The default value is sqlplus.exe.
- USER - Specifies the user name that is used in generated scripts for the Oracle SQL Plus and SQL Loader.
- PWD - Specifies the user password that is used in generated scripts for the Oracle SQL Plus and SQL Loader.
- SERVICE_NAME - Specifies the service name for the Oracle Net protocol that is used in generated scripts for the Oracle SQL Plus and SQL Loader.
- SQLPLUS_EXIT_CMD - If Yes is specified, the SQL Plus EXIT command is generated at the end of DDL scripts. This allows executing DDL scripts from multiple files in batch mode. Possible values - Yes, No. The default value is Yes.
- SQLPLUS_TO_DATE - If Yes is specified, the TO_DATE function with the corresponding date format is generated for DATE columns in SQL INSERT statements for SQL Plus. This allows inserting rows that contain DATE columns when the date format differs from the default date format for Oracle database.
If No is specified, the TO_DATE function is not generated in SQL INSERT statements. Possible values - Yes, No. The default value is Yes.
- DIRECT - Specifies the Oracle SQL Loader method to use either conventional or direct path. Possible values - Yes, No. Yes specifies a direct path load. No specifies a conventional path load. The default value is No.
- LOAD_OPTION - Specifies loading option in the generated SQL Loader control file. Possible values - Insert, Append, Replace, Truncate. The default value is Insert.
- DATE - Specifies the format string in SQL Loader control files for loading dates (year, month, day) into DATE columns from the text files. The default value is "YYYY-MM-DD".
If any value is specified in the DATE_FORMAT option in the [Data] subsection, it overrides the DATE option.
If any value is specified in the TIME_FORMAT option in the [Data] subsection, it overrides the TIME option.
If any value is specified in the DATETIME_FORMAT option in the [Data] subsection, it overrides the TIMESTAMP option.
- TIMESTAMP9i - Specifies the format string in SQL Loader control files for loading Oracle 9i TIMESTAMP data type (year, month, day, hours, minutes, seconds, fractional seconds precision) from the text files. The default value is "YYYY-MM-DD HH24:MI:SS.FF".
- FIXFMT_DECODE_NULLCHAR - Specifies generating DECODE function in the SQL Loader control file for CHAR NOT NULL columns for fixed-length text file. Possible values - Yes, No. The default value is No.
If you what to load fields that contain only blanks into CHAR NOT NULL columns and the text file has the fixed length format, you have to use DECODE function, because SQL Loader treats blanks as NULLs. Set this option to Yes and SQLWays will generate DECODE function to convert NULLs to blanks.
To specify Oracle options using the SQLWays wizard