?
Solved

Attaching and exporting data from an Oracle .odb database

Posted on 2007-07-23
3
Medium Priority
?
902 Views
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.  
0
Comment
Question by:jgbauer
1 Comment
 
LVL 5

Accepted Solution

by:
robyncoffey earned 1500 total points
ID: 19549597
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:

http://download.oracle.com/docs/cd/B28928_01/doc/server.103/b28923/dbtools.htm#CIHFEADH

You can get a copy of Oracle Lite for $100 here:
http://www.awaretechnologies.com/oracleProducts/priceList.html

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

580 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