Oracle: Bin Directory and Utilities to Perform Import

SQLWays Wizard is able to execute the import process automatically. To perform it, user should provide target database credentials and Bin Directory.

To perform import into Oracle database in the Bin directory Option we need to specify a path to the folder which contains sqlldr.exe and sqlplus.exe utilities. By default these utilities are located in the directory like: C:\app\[user_name]\product\[DB_Version]\client_1\BIN\. Otherwise you can find them in the directory specified during the installation process of Oracle database.

If there are no such utilities on the machine where migration process will take place, it means that you need to install the Oracle Client. You can download the Oracle client from the Oracle official website.

Please note that you need to choose “Administrator” installation type of the client to get all the required utilities installed on your machine.

NOTICE: To be able to perform import into Oracle you have to tune the TNS service name and provide this name on the “Target Options” page of SQLWays Wizard tool. Learn how to tune the TNS name.

Bin Directory is a path to a folder containing command line utility of the target database (like psql.exe, sqlcmd.exe, mysql.exe and others). With the help of this utility import process is performed.

So, during the import native utility connects to the target database using database credentials and tries to create all the objects that were converted by the tool.

It is extremely important to provide correct Bin Directory if we want to make an import. If a user doesn't have the appropriate utility on their local machine, it's necessary to install the DB client for a target database.

If you have any other questions, please contact us: support@ispirer.com