Re: exp ./. sql

Hi,

You can try my Schema Viewer at:

http://protasov.simplenet.com

It will create all sql scripts with object definitions for your. New Oracle 8 features are supported too.

Andrew Protasov

> Hello,
>
> 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