exp ./. sql

Hello,

[Quoted] I would like to generate an sql-script out of an existing database (or parts of it). I read, it would be possible to "reformat" the output of exp (with option show=y) using sed under unix.

But i'm working with nt and when i look at the output of exp / show=y, i can't see how the end of a command is indicated - lines longer than (about) 70 characters are simply splitted, but there seems to be no indication if the following line is a new sql command or just the completion of what ended before.

The concrete use would be to import data into a different tablespace. imp obviously tries to use the one originally used before export, not the default tablespace of the user in question; i would have tried to drop the "wrong" tablespace but that would be hard with system :-(

Does anyone have a little program or script to help me or at least the knowledge i'm missing ?

Thanks in advance

Arnold Schommer Received on Mon Dec 21 1998 - 00:00:00 CET