![]() ![]() ![]() |
Ispirer SQLWays Database Migration Software
Files Created for Importing to Oracle
When the target database is Oracle, the following files are created by SQLWays while exporting and converting the source database:
SQL files contain SQL statements used for creating database structure (tables, stored procedures etc.) in Oracle using the Oracle SQL Plus utility.
Data files are ASCII files that contain data from tables in the text format. Each table has its own txt file.
SQLWays uses the Oracle SQL Loader utility to import data from data files (.txt) to Oracle. Control files are used by Oracle SQL Loader to define data file structure (data format, field and row delimeters, import options etc.).
Import scripts are command files used for importing the source database into Oracle. Import scripts execute the SQL Plus utility for creating database structure and the Oracle SQL Loader untility for importing data.
![]() ![]() ![]() |