Re: P.S.

i've read the following on ORACLE underground FAQ (http://www.onwe.co.za/frank/faq2.htm), but i haven't tested it yet:

] You can use the SQL*Plus COPY command instead of snapshots if you need
] to copy LONG and LONG
] RAW variables from one location to another. Eg:

]


] COPY TO SCOTT/TIGER_at_REMOTE     -

] CREATE IMAGE_TABLE USING       -

]        SELECT IMAGE_NO, IMAGE  -

]        FROM   IMAGES;


what works for 'snapshots' shoud work for ordinary tables. perhaps it
helps....