Re: Quick generation of an Oracle table schema

Just download the free version of T.O.A.D. at www.toadsoft.com . Toad is an acronym for Tool for Oracle Application developers. It will do that for you and much, much, much more. The only of the disadvantage of the freeware variant is (and of course it lacks features) you have to download it each month to renew your license.

Hth,

Sybrand Bakker, Oracle DBA

Wesley Gamble <wgamble_at_tmw.com> wrote in message news:7p05m7$7r7$1_at_nnrp1.deja.com...
> Oracle-ites/Informix-ites,
>
> Ideally this message will be responded to by persons with skill in both
> the Oracle and Informix database management arenas. I am of the
> Informix ilk myself, so my terms may be IFMX - centric.
>
> I am made to understand that the equivalent of a "dbschema" command in
> Oracle does not exist (Oracle - heads - the dbschema command in Informix
> generates a SQL script for the creation of one or many database tables
> depending on how it is invoked. Basically, you can generate a SQL
> script to create the structure of a database with one command).
>
> Does anyone know of utilities out there which generate the CREATE TABLE
> statement as well as any other table-specific SQL used to configure a
> table in Oracle (i.e. GRANT/REVOKE statements, CREATE INDEX statements,
> etc.). I'd love to find a script that simply takes a table name as
> input, and spits out a script that will generate all this table specific
> stuff.
>
> Please bear in mind that I am new to the Oracle world - if there are
> some great Web sites out there with this sort of thing (Oracle Users
> Group sites for example), please point me to them and I will find what I
> need there.
>
> Thanks for your help.
>
> --
> Wesley Gamble
> Bison Consulting
> (on site at The Men's Wearhouse)
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Aug 13 1999 - 12:28:13 CDT