I am trying to move data between schemas and tablespaces in an oracle 9i database.
Say I have a schema 'bob'.
bob has a table named 'X'.
X lives in the tablespace 'one'.
what I want to do is move the table into a new schema call 'bill'
I have exported the data using exp.
I have imported the adta using imp. (fromuser/touser)
but the problem is that when the table X is imported into bill... it still lives in the old tablespace 'one'.
Is there a way to specify which tablespace to import into???