Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Create Table Script

Re: Create Table Script

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Tue, 24 Oct 2000 03:24:54 GMT
Message-ID: <20001024.3245400@mis.configured.host>

>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<

On 10/23/00, 8:56:44 PM, Kian Lee <ooiklnews_at_yahoo.com> wrote regarding

Create Table Script:

> How to generate a crete table script from Oracle?
> Right now I have more than 100 tables that need to be prepare in scrip
 t
> method for distribute to client. And those tables were created from
> developer since the development, so I have to consolidate them.
> Therefore is there a easy way to generate a create table script
> including the constraints as well?
 

> For example, in DB2 there is a command db2look.
 

> Thanks in advance.
 

> Regards,
> Kian Lee

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

        The easiest way is to do an export with rows=n. Before doing the imp ort
at the client site it will be necessary to create tablespaces that match  

the ones on your development site. Received on Mon Oct 23 2000 - 22:24:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US