Use this page to set preferred load options and to initiate the load process.
Data Disposition: To first remove all data in the target tables, use the TRUNCATE option. You can also choose to APPEND or INSERT source data in the target table.
Direct Load: Scriptoria includes a direct load statement in the SQL*Loader control file when this option is set to true.
Net Service Name: The Oracle net service name associated with the current ODBC data source. This field may be blank when Oracle is running locally. Note that if you are using the DataDirect Wire ODBC driver, you will need to supply an appropriate Oracle net service name in this field for proper SQL*Loader operation.
Scriptoria will designate the directory shown to contain the SQL*Loader log message file. This location cannot be
modified.
Press to view the SQL*Loader log file. Note the SQL*Loader log is automatically displayed after the load operation completes
SQL*Loader Files
Executable
Then Oracle SQLLDR.EXE path is displayed after the first load operation has been performed. If Scriptoria cannot find the executable, a standard Open File dialog is displayed so it can be located manually. Note that you cannot export Access data to Oracle unless SQL*Loader has been installed.
Output Directories (data and control files):
Type (or use Browse) to specify the directory to store SQL*Loader related files generated by Scriptoria. The default is the Scriptoria for Oracle installation sub-directory …\Temp\Ascii. By default, LOBs are saved in …\Temp\Blobs.
Press to delete all temporary files in the …\Temp\Ascii and …\Temp\Blobs directories.
Important Notes: For optimal performance, create only table definitions before using SQL*Loader. Un-check the Indexes and Relationship options (see Schema Option menu). Then build indexes and relations after all data is loaded.
During the SQL*Loader operation, progress is shown on the status line. When the process completes, the date and time of the concatenated log file is displayed below the file location.
Press to create SQL*Loader control and data files without executing SQL*Loader.
Press to execute the previously built SQL*Loader compatible files.
Press to both create the data and control files and to execute SQL*Loader.