Re: USER DUMP HOW?

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.
Dale_at_DataBee.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dale Edgar
  INET: dale_at_databee.com

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: ListGuru_at_fatcity.com (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).