i am about to do something similar. moving to a differentb
database & user isn't hard, but transferring to a differemt
tablespace is a trick.
firstly, in case you didn't know this already, use EXP/IMP.
so export the user's file.
then create the new user on the new system. but what you
want to do is make his/her default tablespace point to
a REALLY small tablespace (of the same name as was in the
original system). i mean REALLY small. then make the
temporary tablespace point to the one you want the stuff to
go in. then IMP the files. what will happen is that when
there isn't room in the 'default' tablespace, the files will
load into the 'temporary' tablespace (or so i have been assured).
once the load is done, reset the user's default tablespace to
what it shoould be (ie where you just loaded the data).
i THINK this will work.
at one point in the past i editted the EXPDAT.DMP file
and changed all the tablespaces. i DO NOT recommend this. it
was a real pain!
if anyone has any other ideas.....
dan macdonald
