Re: What is the best way to copy 2G table data between two databases

David wrote:

> Hi Ron,
>
> TTS seems not OK since the tablespace contains other tables. Both
> databases are on Solaris.
>
> Thanks,
> David

Create a new tablespace. Do a CREATE TABLE AS into that tablespace. Then move it. The idea of moving 2GB across a database link is a interesting thought. Very interesting. I'm waiting to see if any of those that have suggested it are willing to claim they have done it.

-- 
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)