Re: [Q] how to list all user's table content use dbms_metadata.get_ddl???
- From: mhthomas <qnxodba@xxxxxxxxx>
- To: jkstill@xxxxxxxxx
- Date: Sat, 2 Apr 2005 13:28:39 -0500
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
Other related posts:
