Hi Diego > Or you can write your own scripts, I have found this one between my scripts, > I have never tested, I prefer to use Import/Export for that kind of job.
The easy way to do this is to get the Freeware DBATool. It will read an export file (created ROWS=N) and present you with the DDL contents in a nicely formatted and intuitive manner. It does lots of other things as well - you can generate recreate scripts for all or part of a schema. (for example: a script that recreates a role and every grant it has). The DBATool can strip of storage clause information from every DDL bit code with a single button press or dump the entire schema out to an HTML tree and just browse through the DDL as it suits you. The DBATool is currently in beta. The second beta release (which cleaned up a lot of 9i issues) was just released today. Download the DBATool from http://www.databee.com/dt_home.htm Cheers Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dale Edgar INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
