Attaching and exporting data from an Oracle .odb database

Posted on 2007-07-23
Last Modified: 2013-12-19
Anyone here know anything about older Oracle databases?  

This is a pretty serious problem, a client of ours needs data pulled from an old Oracle lite database.  All he has is the .odb.  Note that this database was not created by a standard Oracle database server.  It was created by an application on his desktop PC which stopped functioning because the software developer turned off the authentication servers necessary for the application's operation.  Unfortunately our client used this application to store 6 years worth of data.  We do not have an existing Oracle infrastructure.  
Question by:jgbauer
    1 Comment
    LVL 5

    Accepted Solution

    With a copy of Oracle Lite you can export the data to an external file, where you could load it into another database.  The Oracle Database Lite Load Utility (OLLOAD) is a command-line tool, which enables you to load data from an external file into a table in Oracle Database Lite or to unload (dump) data from a table in Oracle Database Lite to an external file.  Here's how:

    You can get a copy of Oracle Lite for $100 here:


    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Suggested Solutions

    Creating and Managing Databases with phpMyAdmin in cPanel.
    Many companies are looking to get out of the datacenter business and to services like Microsoft Azure to provide Infrastructure as a Service (IaaS) solutions for legacy client server workloads, rather than continuing to make capital investments in h…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    754 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

    16 Experts available now in Live!

    Get 1:1 Help Now