Re: Scripts to generate tables

From: David Sisk <davesisk_at_ipass.net>
Date: Sat, 14 Aug 1999 21:42:17 -0400
Message-ID: <lLot3.904$tp2.688@news.ipass.net>

Hi Greg:

Here's an easy way:

Take an export of the schema(s) of interest.
Run import on the dmp file with the show option (you can output it to a file). It'll show you all the DDL.

Regards,

--
David C. Sisk
Need tech info on Oracle? Visit The Unofficial ORACLE on NT site at http://www.ipass.net/~davesisk/oont.htm Like original music? Listen to song samples and buy a CD at http://www.mp3.com/disparityofcult

Greg Akins wrote in message <934558393.10906_at_www.remarq.com>...
>Hi,
>
>I need to write a script that will query the data
>dictionary and output a script for table/index/grant/etc...
>create statements.
>
>I figured somebody else must have done this already. Can
>anyone point me to a good resource for prewritten scripts?
>
>-greg
>
>
>
>* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network
*
>The fastest and easiest way to search and participate in Usenet - Free!
Received on Sat Aug 14 1999 - 20:42:17 CDT