Best way to refresh table from different instance

From: <andyho99_at_yahoo.com>
Date: Mon, 23 Oct 2000 16:25:43 GMT
Message-ID: <8t1opt$67v$1_at_nnrp1.deja.com>


[Quoted] I wonder what's the best way to refresh development tables from production database. I used to drop table xyz; then, cretae table xyz as select * from xyz_at_prod. However, someone told me that the indexes will be lost.

Is there a better way to achieve what I want?

Thanks, Andy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Oct 23 2000 - 18:25:43 CEST

Original text of this message