Re: Scripting of existing tables

Take a look at T.O.A.D at www.quest.com

Try the evaluation version - it should be able to do what you want.. ( Not a plug for the company, but our DBAs ( including me ) have found it   extremely useful)

"Support" <support_at_amj.ca> 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
>=---
>

----== 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 =--- Received on Thu Jun 12 2003 - 19:51:20 CEST