Re: What's quicker, table to table insert or extract and sqlload?

In article <4et192$134_at_news.dot.gov>

           rfrazier_at_mailstorm.dot.gov "Richard Frazier" writes:
> How about exporting the original table, then renaming the original to the
> duplicate. Then reimport the original. Presto! two identical tables.

Rick,

Good idea, but I'd never remember all the grants, indexes, dependencies, etc that I'd need to recreate. Although... they should all be in the export file somewhere? I suppose I could do an export before the rename, rename and import my duplicate, then run the import with rows=n????

Thanks, it's all food for thought.

Andy

-- 
Andy Hardy (Internet: aph_at_ahardy.demon.co.uk, CIS: 100015,2603)
PGP key available on request
===============================================================
No good deed goes unpunished.