Re: Tables and Indexes
Date: 1995/05/22
Message-ID: <michel.lalonde.16.000FBCC1_at_sit.ulaval.ca>#1/1
In article <3pq9pr$9h6_at_pheidippides.axion.bt.co.uk> Karl Zdero <karlz_at_pst.bt.co.uk> writes:
>From: Karl Zdero <karlz_at_pst.bt.co.uk>
>Subject: Tables and Indexes
>Date: 22 May 1995 15:15:06 GMT
>Apart from using "imp" , is there a way to get tables and indexes
>from another machine.
>You see, the database I want the tables and indexes from is too big.
>I only want a sample of the data, but I must have the indexes too.
>If I do a
> create tablea as select from tablea_at_machine1
>I only get the table data, not the index.
>Same with the COPY command.
>If I use import, then I have to edit a lot of the junk in the ddl
>so it will load on to my machine. Very messy!
Try to import with ROWS=N you will get the structure but no data. Then insert into ... select ...
Michel Lalonde. Received on Mon May 22 1995 - 00:00:00 CEST