Re: Scripting of existing tables

Run export with ROWS=N. You can then dump DDL commands using INDEXFILE of imp or SHOW=Y of imp.

HTH,
Brian

Support wrote:
>
> Sorry... what I want to do is to reproduce an entire schema from our
> development server to other servers. I need to recreate all tables, keys,
> index's..etc by way of a script. On the production server our installation
> program will run the foo.sql script and recreate the schema complete with
> all tables. This is simular to the MSSQL server which we would tell it to
> "script all tables".
>
> "TurkBear" <john.greco_at_dot.state.mn.us> wrote in message
> news:2vahev0j26ljqlkdq8mgigs3nvbggh1fuu_at_4ax.com...
> >
> > Please define what you mean by scripting the tables?
> >
> > "Support" <support_at_amj.ca> wrote:
> >
> > >Hi,
> > >I'm trying to automatically script all the tables within a schema in
> > >oracle8i, however I've been unsuccessful. Does anyone know how this is
> done?
> > >
> >
> >
> >
> > ----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet
> News==----
> > http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000
> Newsgroups
> > ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption
> =---

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"