Re: Oracle Export -> SQL-Statement

Someone on this NG may have a script for you to do it.

However, i recommend downloading T.O.A.D (Tools for Oracle Application Development)......*ribbit!* ;-)

Anyway, amongst other things, it will give you, in its Schema Browser, for each table you click on, a script which will create the field definitions, field types, any indexes and constraints etc in that table.

The free toad can be downloaded from www.toadsoft.com

HTH, Mark

Jan Lessing <lessing_at_med.uni-goettingen.de> wrote in message news:<3BF220AA.730C3084_at_med.uni-goettingen.de>...
> Hi
>
> I'm new in that newsgroup and new in oracle, but I've got knowledge in
> working and administrating databases. I am working on an "old" oracle 7
> database server on a Novell Netware 3.12 platform.
>
> I don't know how to export SQL-statement to build the same database
> structure with tables and data on a different database-plattform. Is
> there a way to export a SQL-statement like create table ... of an
> existing table? Where can I find informations about that, because I
> can't find any printed oracle literature in my office.
>
> Thanks for your help
Received on Wed Nov 14 2001 - 09:58:40 CST