Re: Importing data from Access

From: Tom Best <tombest_at_firstusa.com>
Date: 30 Jul 2001 11:22:08 -0700
Message-ID: <99ab87b0.0107301022.88773f6_at_posting.google.com>

If this is a one-time data migration, I'd recommend doing ASCII outloads of the Access tables (one file per table) and load them into equivalent Oracle tables with SQLLDR. From there, you work entirely inside Oracle to get the data from the staging tables into the production tables.

Tom Best Received on Mon Jul 30 2001 - 20:22:08 CEST

This message: [ Message body ]
Next message: Tony Hunt: "Re: How can oracle receive a variable that is set from an Windows NT session?"
Previous message: Tony Hunt: "Re: Importing data from Access"
Maybe in reply to: cisco: "Re: Importing data from Access"
Next in thread: Tony Hunt: "Re: How can oracle receive a variable that is set from an Windows NT session?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message