Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create Table Script
>>>>>>>>>>>>>>>>>> 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