Re: Can I export only the schema of one table ?

From: Bob Fazio <bob_fazio_at_hotmail.com.no.spam>
Date: Tue, 07 Sep 1999 23:42:23 GMT
Message-ID: <zphB3.3627$E46.8526@news.rdc1.pa.home.com>

The second part of this is to actually get the schema.

imp un/pw full=y indexfile=schema.sql (this assumes you just exported the tables that you really wanted.

the file schema.sql will have the indexes in the script and the tables commented out.

You can also use the show=y option and log=filename.sho The only problem with that is that
is really hard (I have an awk script that reconstructs) to get anything useful out of it. The advantage to
the show script is that it will also have all constraints and grants on the table also.

Jean-Luc <jeanluc_at_zap.a2000.nl> wrote in message news:FHoC2x.A2z_at_ahisinfr.xs4all.nl...
> Use rows=n in your exp command
>
> exp userid=un/pw tables=tablename rows=n
>
> Jean-Luc
>
>
>
> Huy Vu wrote in message ...
> >Hi all,
> >
> >I don't know if oracle allows me to extract just the schema of one table?
> >
> >Thanks in advance for any help.
> >
> >H.V
> >
> >
>
>
Received on Tue Sep 07 1999 - 18:42:23 CDT