Originally posted by anandkl
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
change you user's default tablespace to user2 before import and make sure he hasnt got unlimited tablespace priv