Use this page to load Access data into corresponding Oracle tables.
Only Access tables with corresponding Oracle tables for the selected Owner/User are shown on this page.
Use the arrow buttons to select one or more entries.
Note that Scriptoria ensures that foreign-keys and other triggers that would prevent the successful data population are first disabled and then re-enabled after load process completes.
Notes:
The Oracle SQL*Loader executable (e.g., sqlldr80.exe) must be installed before this feature can be utilized. SQL*Loader is NOT included when only the Oracle Client software is installed.
Scriptoria automates the SQL*Loader process as follows:
Separate SQL*Loader compatible ASCII files (*.dat) are built using data from each of the selected Access tables.
When BLOB and / or CLOB columns are specified (requires Oracle 8), Scriptoria creates LOB files that it instructs SQL*Loader to use.
SQL*Loader control files (*.ctl) describing the associated ASCII (and LOB) files are created.
A DOS batch file (*.bat) is constructed for executing SQL*Loader commands supplied by Scriptoria for each table. The batch file also concatenates all SQL*Loader generated log files (*.log), which is available for display as shown below.
The SQL*Loader ASCII files generated by Scriptoria are stored in the Temp sub-directory of the Scriptoria installation directory, e.g., c:\Scriptoria for Oracle\Temp\Ascii and LOBS are stored in c:\Scriptoria for Oracle\Temp\Blobs. They are NOT deleted after the load completes.