Hi All, Also on 9i and earlier (I think) the "INDEXFILE" parameter of the imp command generates the DDL for tables and indexes too! Ron -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of mhthomas Sent: 02 April 2005 19:29 To: jkstill@xxxxxxxxx Cc: Ian.Cary@xxxxxxxxxxxxxxxxxxxx; mccdba1@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: Re: [Q] how to list all user's table content use dbms_metadata.get_ddl??? Hi, On Mar 31, 2005 1:39 PM, Jared Still <jkstill@xxxxxxxxx> wrote: > On Mar 31, 2005 2:30 PM, Ian Cary (C) <Ian.Cary@xxxxxxxxxxxxxxxxxxxx> wrote: > > select dbms_metadata.get_ddl('TABLE',table_name,owner) > > from dba_tables > > where owner =3D 'USER1' > > I tried using this recently on 9i databases and found it to be extremely slow. > About 40 minutes I think to get ddl for ~300 tables. > > OTOH I found that using Perl to parse the DDL from an export file > created with rows=n was extremely fast. > As you probably already aware, if you are a dba the impdp in 10g generates the create ddl syntax very nicely from an who database expdp (data pump). Regards, Mike Thomas -- //www.freelists.org/webpage/oracle-l -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 01/04/2005 -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.1 - Release Date: 01/04/2005 -- //www.freelists.org/webpage/oracle-l