Changing user's tablespace

[kburrows]

I believe with 8i you can use the

alter TABLE DEPT move tablespace users
storage ( initial 10240 next 10240
minextents 1 maxextents 121
pctincrease 50 freelists 1);

alter INDEX PK_DEPT rebuild tablespace users
storage ( initial 10240 next 10240
minextents 1 maxextents 121
pctincrease 50 freelists 1);

Just make sure you then change the users default tablespace to the one you want it to be.