Re: view create table statements

actually i think there is a view from which you can actually view the creat statements only of the views, definitly not for the tables.. i dont remember the table. let me do a search and i will get back to you...

Bjoern Henning wrote:

> Is there a way of viewing the create table,view.. of an existing
> oracle database? I don't want to use a tool, just generating a file
> would be perfect. I need this for transforming a complex ora-db into
> mysql.
> thank u

--

Atul Agrawal                     | Atul Agrawal
Masters Student, CS Deptt.       | 3501, St Paul Street,
Johns Hopkins University         | Apt # 1018,
3400, N Charles Street, NEB 224  | Baltimore,
Baltimore, MD 21218.             | MD 21218.
                                 |
Hello: 410-516-8291 (Lab)        | Hello: 410-366-6852 (Resi)