I want to import data from a user "Payroll" in Oracle9i database to another user with same name in Oracle10g. The oracle9i user is in system tablespace but I have placed the 10g user in another tablespace "ts_payroll". Now I want all the tables to be imported in new tablespace (ts_payroll). What do I need to do because when I run import utility, it imports all the tables in system tablespace?

>What do I need to do because when I run import utility, it imports all the tables in system tablespace?
Before running import you need to CREATE the empty tables (& indexes?) in the new tablespace; then use IGNORE=YES with imp