Choose your database:
MS SQL Server
SQL Anywhere

Subscribe to our news:

Oracle Data Wizard FAQ

You are welcome to look through the following Frequently Asked Questions list for getting to know the answers to the most commonly asked questions about Oracle Data Wizard.

If you want to ask a question which is not in the list you may apply to our support team.

What is Oracle Data Wizard?

Oracle Data Wizard is a powerful Windows GUI utility for managing your Oracle data. It provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly.

With the utility you can easily convert any ADO-compatible database to Oracle database, export data from Oracle tables and queries to the most popular formats and import data into the tables, generate ASP.NET scripts for the selected tables and queries.

Is it possible to try Oracle Data Wizard before buying?
Yes, of course. The latest fully functional trial version is always available for downloading.
I want to use your software for educational purposes. Can I get a discount?
Yes, you can. Feel free to choose a non-commercial license. Exact prices can be obtained on the purchase page.
We intend to buy multiple licenses. Is it possible to obtain a discount?
Yes, certainly. You can get a volume discount purchasing 3 and more licenses for the same product as well as a cross-selling discount purchasing multiple different products at a time. Also you can get a great discount purchasing a bundle that includes Oracle Data Wizard.
I would like to resell Oracle Data Wizard to my customers. What are your reseller's discounts?
You are to discuss reseller's policy with our sales department.
Which license type can I select?
You may choose a non-commercial license if you use the software for non-commercial purposes in non-business, non-commercial environment. You should purchase a business license to use the software in a corporate, government, or business environment.

Single license means that a copy of the software is allowed to be used only on a single computer and only by a single user at a time. If you wish to use the software for more than one user, you will need a separate license for each individual user (click the "Order now" button to see volume discounts). Site license means that the software is allowed to be used without limitation on count of installations and users within one organization.

All our products and bundles are shipped with 12 months of free upgrades (minor and major ones) or with 36 months of free upgrades for a quite small additional fee.

Can I deploy a single license for both desktop and laptop?
A single license can be installed on a single computer. However, we offer a special allowance which authorizes you to deploy Oracle Data Wizard on both desktop computer and portable computer, laptop, or other mobile computer with a single license, as long as it is not being used simultaneously.
How can I find out the date of my current product version release?
Product versions are formalized according to the date of release. For more information, please refer to the appropriate news article.
What are system requirements for installing your software?
  • Pentium PC or higher;
  • Windows NT4/2000/XP/Vista/Windows 7/Windows 8/Windows 10;
  • 1 GB RAM (2 GB or more is recommended);
  • 50 MB of free hard disk space;
  • SVGA-compatible video adapter.
  • 32-bit version of Oracle client software.
Which Oracle database server versions are supported by your software?
Oracle Data Wizard can be used with any Oracle database server starting from version 8i. The Express Edition is supported too.
I'm getting the "ORA-12154: TNS:could not resolve the connect identifier specified" error connecting to a database.
  • Make sure that "TNSNAMES" is listed as one of the values of the NAMES.DIRECTORY_PATH parameter in the Oracle Net profile (SQLNET.ORA).
  • Verify that a TNSNAMES.ORA file exists and is in the proper directory and is accessible.
  • Check that the net service name used as the connect identifier exists in the TNSNAMES.ORA file.
  • Make sure there are no syntax errors anywhere in the TNSNAMES.ORA file. Look for unmatched parentheses or stray characters. Errors in a TNSNAMES.ORA file may make it unusable.
For more details, visit
I keep on getting the "ORA-XYZAB" error.
Please try to find an answer at (of course you have to use your error code instead of XYZAB).
I'm getting the "Initialization error Could not locate OCI dll" error message connecting to a database.

First of all, please make sure that you have installed an Oracle client software. Next, you can either copy Oracle libraries from ORAHOME folder to ORAHOME\bin one as described here or specify the OCI.dll location in the command line (for example, changing a desktop shortcut) as follows:

OracleMaestro.exe OCIDLL=<full_path_to_oci.dll>

OracleMaestro.exe OCIDLL=C:\oraclexe\app\oracle\product\10.2.0\server\BIN\oci.dll

I'm having problems connecting to Oracle with your software under Windows 7 x64.

Try the following solution:

  1. Download a Win32 version of Oracle Instant Client Basic (not Basic Lite) from the Oracle website.
  2. Extract all the files from the archive to a directory (e.g. C:\Oracle\incBin).
  3. Create a directory (e.g. C:\Oracle\incTNS) and copy there your TNSNAMES.ORA.
  4. Create a new environment variable TNS_ADMIN=C:\Oracle\incTNS.
  5. Add the C:\Oracle\incBin directory to the system PATH.

It is possible to perform such actions as data export or import at defined time automatically with your software, isn't it?
Yes, it is. Data Wizard includes a scheduler to create such tasks. After creating a task it can be executed in background mode at a specified time.
There is a necessity to import data into Oracle tables. What file formats are supported by your software?
Data Import Wizard allows you to import data into Oracle tables from the following available formats: MS Excel, MS Access, XML, DBF, TXT and CSV. You will be surprised with easy adjustment of the source file columns and the destination table fields.
Is it possible now to export data from Oracle tables and queries selected from different databases to RTF files?
Use Data Export Wizard to export data to any of the 14 available formats: MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX, and SQL.
Can I execute a scheduled task any time irrespective of its repetition properties?
Yes, you can run the configured scheduled task at any time you need. Just open Common | Task Scheduler, select the task in the task list, and click Execute in the navigation bar or in the popup menu.
Can I cancel task executing at a specified time without deleting it?
Yes, you can. Just open Common | Task Scheduler, select the task in the task list and use the disable/enable option.
How can I create a template with Oracle Data Import Wizard?
It is easy to create the template using the wizard. Just click the More button at the last wizard step and select the Save Template item to save the current configuration.