Re: how to save my tables structures in a file?

From: Michel Cadot <micadot2removethat_at_free.fr>
Date: Wed, 1 Oct 2003 20:44:00 +0200
Message-ID: <3f7b1faa$0$2803$626a54ce@news.free.fr>

"circuit_breaker" <circuit_breaker_at_canada.com> a écrit dans le message de news:2863e14b.0310011001.1b31a1a6_at_posting.google.com...
> Hi,
>
> I created a database in which I have several fields. I would like to
> rebuild this structure on another Oracle box and I'd like to know how
> to "export" the tables data structure to a file in order to re-create
> it on the other box.
>
>
> Thank you.

At least 2 ways:
- export: exp rows=n tables=...
- procedure: dbms_metadata.get_ddl

Hope this helps
Michel Cadot Received on Wed Oct 01 2003 - 13:44:00 CDT