Exporting Entire Schema DDL

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:09:39 CET