From: michel.lalonde@sit.ulaval.ca
Subject: Re: Tables and Indexes
Date: 1995/05/22
Message-ID: <michel.lalonde.16.000FBCC1@sit.ulaval.ca>#1/1
sender: news@athena.ulaval.ca
references: <3pq9pr$9h6@pheidippides.axion.bt.co.uk>
organization: DES, SIT,U. L.
newsgroups: comp.databases.oracle


In article <3pq9pr$9h6@pheidippides.axion.bt.co.uk> Karl Zdero <karlz@pst.bt.co.uk> writes:
>From: Karl Zdero <karlz@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@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?

Try to import with ROWS=N you will get the structure but no data.
Then insert into ... select ... 

Michel Lalonde.