Editing export dump files

For reasons beyond our control, someone did an export/import of data which ended up stripping off the eighth bit. The data contains international characters (Norway/Sweden/Denmark/France/Iceland...).

Thus characters in the 'upper-ascii' realm has been stripped of one bit, ending up as 'control characters',
(ascii 01 through 32).

The data has been imported and new records have been entered into the database. The original dump file is therefore not of much use to us.

This is a fairly large system 150+ tables so changing things using SQL or PL/SQL is our last resort.

I have been involved with a similar situation some years ago where we used the following solution:

1. Shutdown database.
2. Export all data.
3. Edit the dump file using UNIX sed/awk or similar exchanging known characters for the correct 8 bit equivalent. Some characters will be lost. The most relevant for us will remain (nordic characters).
4. Truncate all tables, disable constraints/indexes etc.
5. Import edited data
6. Enable constraints etc.

I know that this can be done. I don't however have the Unix scripts (or C-program) to do it. So for purposes of saving some time, I wonder of someone have such scripts available or know where I can get them? (URL.?)

Database is 7.2.2 on Netware.
(and, yes I know that his is unsupported, but in desperate
 times.. etc.).

Many thanks,
Haakon Received on Tue Aug 11 1998 - 05:52:20 CDT