Re: Exporting Entire Schema DDL

download toad
http://www.quest.com/solutions/download.asp "Steve" <stevenmgarcia_at_hotmail.com> wrote in message news:4c049a8c.0111021809.4ff83306_at_posting.google.com...
> I have a need to export the entire schema DDL into script files that
> may be executed, for instance, from sqlplus.exe or sqlplusw.exe. I'm
> seeking some advice as to the best way to achieve that.
>
> I have tried a few things:
>
> 1) looking at an export dump file generated by exp.exe. The dump
> file is DDL only, but I'm noticing a bunch of weird characters in it
> (nulls, exclaimation points, etc.). Some of these characters I can
> easily strip (like the header and footer), but there are these odd
> characters in the procedure declaration section, for instance, that
> would be difficult to remove.
>
> 2) I've started writing some sql scripts that dump the DDL manually,
> and I'm trying this because we only use tables, procedures, packages,
> indexes, constraints, sequences, and views. We don't use triggers,
> database links, etc. However I'm worried that I won't grab everything
> with this method, I would much rather rely on an export from the
> oracle binary utility.
>
> Any suggestions as how you would go about this? I appreciate any
> advice.
>
> Thanks, Steve
> stevenmgarcia_at_hotmail.com
Received on Sat Nov 03 2001 - 03:42:33 CET