I'd be tempted to export the data from the access databases into flat files
and use sql*loader to import into a single schema. Obviously this is a lot
of work. 5*25 different loads (I for each table). By doing it this way
though you get a lot of control over your single schema and you can ensure
that constraints aren't violated because of conflicting or duplicate data
from your 5 different sources.
HTH a bit anyway.
"rockcogar" <rock_cogarNOroSPAM_at_my-deja.com.invalid> wrote in message
news:0634c680.ab9dfedb_at_usw-ex0103-019.remarq.com...
> Hi,
>
> I have just been handed 5 instances of the same Access 97
> database (that were updated by different people) and told to put
> it into Oracle and rollup all the data into one schema !
>
> The database has 25 tables and 145 columns. I have imported all
> of the Access 97 "databases" into 5 different Oracle 8.1.5
> schemas and I now need some advice on what kind of approach I
> should use to rollup all the data into one (yet another) schema !
>
> Any Ideas ?
>
> Thanks,
> Rock.
>
>
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
> The fastest and easiest way to search and participate in Usenet - Free!
>
Received on Fri Feb 25 2000 - 03:55:55 CST
