Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] how to list all user's table content use dbms_metadata.get_ddl???

RE: [Q] how to list all user's table content use dbms_metadata.get_ddl???

From: Ron Perrie <ron.perrie_at_perriepartners.co.uk>
Date: Sat, 2 Apr 2005 20:00:54 +0100
Message-Id: <E1DHnrg-0000y5-00@mrelayng.kundenserver.de>


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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of mhthomas
Sent: 02 April 2005 19:29
To: jkstill_at_gmail.com
Cc: Ian.Cary_at_ordnancesurvey.co.uk; mccdba1_at_yahoo.com; oracle-l_at_freelists.org 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_at_gmail.com> wrote:
> On Mar 31, 2005 2:30 PM, Ian Cary (C) <Ian.Cary_at_ordnancesurvey.co.uk>
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

--
http://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
 

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Apr 02 2005 - 14:04:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US