Re: scripts "create table" ddl statement

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Thu, 27 Mar 2003 12:28:26 +1100
Message-ID: <xisga.565$1s1.4140@newsfeeds.bigpond.com>

Version?????????????????????????

I only ask, because in 9i there's a package to do precisely this. Which I would explain in more detail if I thought for one minute it might be applicable to you... but since you leave me guessing, it hardly seems worthwhile.

Otherwise, and for all versions, do an export, and then an import with rows=n. indexes=n, indexfile=blah.txt ignore = y. You'll produce a text file called blah.txt which contains the entire DDL statement for any tables included in the original export.

Regards
HJR "Maria" <evoradba_at_yahoo.ca> wrote in message news:351fd9d6.0303261648.4da86d2f_at_posting.google.com...
> Hi all
>
> Is there any Oracle scripts that can create "create table" ddl
> statement from the database?
>
> Thanks
> Maria
Received on Wed Mar 26 2003 - 19:28:26 CST