Re: Schema to Text File

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 14 Sep 2001 15:33:25 +0200
Message-ID: <tq420vtk5dp8e0_at_news.demon.nl>


"JCAP" <joao.capitolino_at_ibusiness.pt> wrote in message news:9nsqsc$s0l$1_at_venus.telepac.pt...
> Hi,
>
> Do you know if there is any software that let to export a database schema
to
> SQL Commands (text file) to recreate the same schema structure in another
> place?
>
> Thanks,
> Joao
>
>

[Quoted] [Quoted] export, rows=n, will dump only the table and index definitions and can be used anywhere.
Apart from that you can dump a schema with TOAD, but why do that if you can use exp for this purpose.

(No spam for Hora, Keeptool, Chyfo/Inspirer and other single-developer products please)

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Fri Sep 14 2001 - 15:33:25 CEST

Original text of this message