Copy Database structure from Oracle 10g to Access 2007

Posted on 2008-11-08
Last Modified: 2013-12-19
I want to copy Full Database from Oracle 10g to Access 2007.

That meaning copy Tables, Relationship between tables

Can any body help me
Question by:interbus
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    could you please clarify why you want to do that?
    also, what size is that oracle database?
    LVL 17

    Expert Comment

    I will tell you how I would do it, using SQL Server Integration Services. SSIS.
    Copy the Oracle db to SQL Server first, then to Access. Or I might try to go directly from Oracle to Access directly. But probably not.
    LVL 10

    Expert Comment


    you can import data directly via ODBC from other databases to MS Access. See here for a simple example:

    All you need is to setup an ODBC connection to your Oracle database. See the oracle docs for this, or ask the Oracle DBA to help you.


    Author Comment

    Good answer kukno

    I know this way to import data directly

    but I need to pring all tables with relationship identification on oracle

    this way only import tables without relations

    kukno you near to get 500 points but give me what I want

    Accepted Solution

    Question PAQ'd, 500 points refunded, and stored in the solution database.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    Suggested Solutions

    You can provide a virtual interface for remote stakeholders in a SWOT analysis through a Google Drawing template. By making real time viewing and collaboration possible, your team can build a stronger product.
    Communication between departments might not happen in two different languages, but they do exist in two different worlds. With different targets and performance goals the same phrase often means something completely different to each party. Learn ho…
    This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
    Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now