Re: Import/export

pblair_at_pcug.org.au (Paul Blair) wrote:

>I'm no expert in ORACLE, but I do need a bit of advice, so here goes.
>
>We have an ORACLE database, with an SQL Windows front end. The
>database needs major updating, and the SQL-W front end is a dog.
>
>We would like to tip the contents of the tables into something simple
>to allow fast alterations, then tip that lot back into Oracle.
>
>I see functions like IMP and EXP, but it seems that they produce only
>an archive, non-readable by other means. So, if we try to edit
>anything created with EXP, we face IMP problems.
>
>Can anyone suggest that (1) I'm wrong about all this or (2) the
>situation is as described. If (2), then are there any other methods
>or utilities that would allow us to do the job?
>
>Appreciate any advice
>
>Paul Blair
>Canberra, Australia

I don't know what the nature of your "major" update is, but we do a major update every month to our data warehouse from data in a Universe (Pick) database. The way we do it is to create flat files of Universe, sqlload load them into temporary "delta" tables in Oracle, and use SQL to apply the changes.

Sqlload is a flat-file loading tool that ships with Oracle.

--
Chuck Hamilton
chuckh_at_ix.netcom.com

If at first you don't succeed, skydiving isn't for you.