Re: Tables and Indexes

From: <james.lawrence_at_EPAMAIL.EPA.GOV>
Date: 1995/06/08
Message-ID: <james.lawrence.56.000E56B1_at_EPAMAIL.EPA.GOV>#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!
 

>Is there an easier way?

Do an export without the data, import that, and then load the tables with an insert into tablea as select * from tablea_at_machine1 where rownum < 100 or whatever; Received on Thu Jun 08 1995 - 00:00:00 CEST

Original text of this message