Problems on copying a database user from one tablespace to another on the same instance

I tried to export a user with
BUFFER=8192
FILE=G:\export.dmp
COMPRESS=Y
GRANTS=Y
INDEXES=Y
ROWS=Y
CONSTRAINTS=Y
LOG=G:\export.log
OWNER=(USER1)
RECORDLENGTH=8192 and then reimport the data into a new user on a new tablespace with BUFFER=8192
FILE=G:\export.dmp
SHOW=N
IGNORE=N
GRANTS=N
INDEXES=N
ROWS=Y
LOG=g:\import.log
DESTROY=N
FULL=N
FROMUSER=(USER1)
TOUSER=(NEWUSER)
RECORDLENGTH=8192
COMMIT=N The problem is that the import always creates the tables in the the tablespace from user1 and not in the default-tablespace of the new user (NEWUSER).

Peter Received on Sun Dec 10 2000 - 13:34:08 CST