content of exported file

[a128]

Hi,

When I look at the content of an exported file, it contains a header followed by basically bunch of SQL statements.

If I have an existing database but don't have the scripts to recreate schema (including constraints, etc.), the best way to generate a script for the schema is to extract from the content of the exported file? Is it a reliable way?

Is there a better way to generate a script for the schema in an existing DB?

Thanks,

[adewri]

Hi

Just do a simple import with rows=n, that way u will get all ur schemas (users,tables,indexes,views,constraints,procedures,packages,triggers etc) excluding data.

Regards
Amar

[jovery]

If you want to create a set of schema build scripts take a look at the free datatool at http://www.databee.com

If you follow Amar's advice the datatool above reads the exprt file and produces the schema defintion.

It's quite neat and save a lot of time.

Regards