you can use the copy command for the longs - but I don't think it
works for long raws - write a pl/sql that pulls it in in 32k chunks or create
temp tables with the pk and long raw and do the insert/update
routine.>>> [EMAIL PROTECTED] 11/25/02 09:59AM
>>>
OK, so
you can't CTAS on tables with LONG or LONG RAW columns, and now I find out that
the same restriction exists on Alter Table ... Move. So, is there
any other option to move these tables from one tablespace to another without
exp/imp or converting them to LOB?
Thanks,
Mike
This transmission is intended only for use by the addressee(s) named herein and
may contain information that is proprietary, confidential and/or legally
privileged. If you are not the intended recipient, you are hereby notified that
any disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received
this transmission in error, please immediately contact the sender and destroy
the material in its entirety, whether in electronic or hard copy format. Thank
you.