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).

Reply via email to