when i export it into the new database..i am getting error
'tablespace user1 not found'

The tablespace i want the tables to be moved is user2

regards
anandkl