nabaig,

Funnily enough, I just typed 'move table long datatype' in the search box on Metalink and found plenty of information regarding your problem - for example a forum entitled:

'ALTER TABLE MOVE table between tablespaces failed on LONG datatype'

Try again (a bit harder)!

You may find that an export/import is your only option, also are you running Standard or Enterprise edition?

Regards,