Re: How to create a DDL for a schema

From: Odd Bjørn Andersen <odd.andersen_at_ergo.no>
Date: Fri, 21 Oct 2005 10:44:08 +0200
Message-ID: <1129884250.915383@makrell.interpost.no>

OK, I know that this will work. But if I for some reason have to connect as SYS, is there a way to generate a ddl with the use of this utility ?

Regards
Odd B

---

<gareth_at_jamms.org> wrote in message
news:1129727799.325342.312810_at_g43g2000cwa.googlegroups.com...
> set long 20000
> connect XAL_SUPERVISOR/<password>
>
> SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
> FROM USER_TABLES u;
>
Received on Fri Oct 21 2005 - 03:44:08 CDT