Re: Export Database Tables only..no Data ?????
From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 21 Jul 2001 21:48:55 GMT
Message-ID: <thlaibbgmb1v79_at_beta-news.demon.nl>
Date: Sat, 21 Jul 2001 21:48:55 GMT
Message-ID: <thlaibbgmb1v79_at_beta-news.demon.nl>
"Jacques Victor" <jacquesv_at_digicore.co.za> wrote in message
news:3b1a9981.0_at_news1.mweb.co.za...
> Hi All.
>
> I want to export all tables with their setup parameters as well as indexes
> (NO DATA MUST BE EXPORTED) to a flat file..eg..myexport.sql.
>
> I want to use this file to create a new Oracle DB on a different machine.
>
> Does anyone know how to do the export?
>
> Thanks in advance for any help
>
> Kind Regards
> Jacques
>
>
use rows=n and type exp help=y before asking such questions. (or read the documentation)
Hth,
Sybrand Bakker, Oracle DBA
Received on Sat Jul 21 2001 - 23:48:55 CEST