Table of contents
- What is EMS Data Pump for Oracle utility?
- What do I need to start working with EMS Data Pump for Oracle?
- I‘ve downloaded a trial version of EMS Data Pump for Oracle, but not all records of the tables are exported. What’s the reason for this?
- I’m trying to import data from MS Access. When I open up a table it shows indices(0), constraints(0) and I cannot select them. How can I fix this?
- I'm testing Data Pump utility to convert an MS Access 2000 database to Oracle but it raises an error of access violation in module msjet40.dll.
Q:
What is EMS Data Pump for Oracle utility?
A:
EMS Data Pump for Oracle is an excellent utility for converting databases and importing table data from an ADO-compatible source (e.g. MS Access, MS SQL database or any other database with ADO support) to Oracle databases. Easy-to-use wizard application allows you to build the ADO connection string, select tables, fields and indices for converting, view and edit SQL script for generating target Oracle database and select tables for import.
Q:
What do I need to start working with EMS Data Pump for Oracle?
A:
First of all you must have an opportunity to connect to some local or remote Oracle server. Besides you need your computer to satisfy the system requirements of EMS Data Pump for Oracle.
Q:
I‘ve downloaded a trial version of EMS Data Pump for Oracle, but not all records of the tables are exported. What’s the reason for this?
A:
This is a limitation of the trial version which exports only 10% of all records. With a registered version all the records are processed.
Q:
I’m trying to import data from MS Access. When I open up a table it shows indices(0), constraints(0) and I cannot select them. How can I fix this?
A:
The solution to this problem is to use the Microsoft Jet OLE DB Provider for establishing connection to your Access database.
Q:
I'm testing Data Pump utility to convert an MS Access 2000 database to Oracle but it raises an error of access violation in module msjet40.dll.
A:
Try to reinstall the Microsoft Data Access Components (MDAC) 2.8. You can download it from the following page: http://www.microsoft.com/downloads/search.aspx?display.