Best way to refresh table from different instance

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 - 11:25:43 CDT