Re: re-create large tables

arjan wrote:

> A set of large tables need to be re-created within a relatively small
> time window. Does anyone have suggestions on how to do this without
> making use of the import/export utility? Thanks.

A bit of explanation is required. Start with these.

1. Hardware and operating system(s)?
2. Oracle version and edition?
3. In the same database or in a different one?
4. Define 'large'?
5. Define 'small'?

Have you considered transportable tablespaces?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)