Loading MDB file in to oracle database

ksbabu

Hi Experts,

I have SALES.MDB file which contain Agg_tables and dimensions information,i created ms access-odbc connection upto here everything is perfect.

through command prompt tried to load data into oracle database but throwing error like

IMP-00002: failed to open hyperionsales.mdb for read

Import file: EXPDAT.DMP >

I created schema in database and gave dba permissions to schema.where i missed please help me.

Thanks,

Sateesh

Andrew Fomin.

Documentation: https://docs.oracle.com/cd/B28359_01/server.111/b28319/exp_imp.htm#i1004670

What Are the Export and Import Utilities?

The Export and Import utilities provide a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configurations.

More info: oracle import mdb

cesar.advincula.o

You are using MDB (microsoft access database) . DMP files are the files which are using to import/export oracle database objects, for that reason when you try to use the import/export utility you get "IMP-00002: failed to open hyperionsales.mdb for read" .

If you want to migrate your from MDB to Oracle,  you should test other mechanism.

https://dbasolved.com/2014/03/25/open-and-migrate-microsoft-access-in-oracle-sql-developer-4/

The post is using this versions:

• Microsoft Access 2010
• Oracle SQL Developer 4.0  (4.0.1.14.48 w/ JDK 1.7.0_51)
• Oracle Database 12c (12.1.0.1)

Another thing, this is a database question, if the answers are not enough to solve, maybe you should move to Oracle Database Space.

ksbabu

Thanks for the reply,you have shown me the link is helpful to me

Gianni Ceresa

Just in case for the future ...

For database questions will be better to ask on one of the Database  forums instead of the OBIEE one (it gives you more chances to get the answer and also help others looking for the same thing but looking in the right place for it ...)