posted 19 years ago
Hi,
I have an Oracle 9i db with an assortment of tables, indices, and constraints that we want to export for use on another computer( minus data ).
What do you recommend for exporting said information in an easy-to-read format? The EXP utility supplied with oracle appears to require that each row and index be typed in individually and it doesn't present an easy-to-read output.
Is there a particular way to use EXP or a utility program out there that will do this for me? Bonus points if it can compare two and SQL Scripts and output the difference.
Thanks ahead of time,
Kevin Wright