Tables and Indexes

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? Received on Mon May 22 1995 - 00:00:00 CEST