Re: Table Structure Question

There are several free tools that can provide you with this (Toad). You already have the export feature you can use. At you OS prompt and being logged in as the Oracle owner;

$ exp schema owner / password file=/tmp/file.dmp owner='schema name' rows=n (will not export data)

This will export the DDL which you can reverse by importing that export dump file into another system.

I use SQL Navigator and TOAD.

In article <8sojmh$ccd$1_at_nnrp1.deja.com>,   ooiklnews_at_yahoo.com wrote:
> How do I grep all the table structure including the constraints
> (primary key) in an Oracle Database with the "create table" scripts?
 So
> that I can create the whole set of table in other machines. For
> example, in IBM DB2 there is a command "db2look", it will grep all the
> table structure with the create table script and output into a file.
>
> Thanks in advance.
>
> Regards,
> Kian Lee
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Cry on someones elses shoulder


Sent via Deja.com http://www.deja.com/
Before you buy.