then you dont need imp/exp, you can use
create a new tablespace aaaa
alter table xxx move tablespace aaaa storage(initial 4M next 4M pctincrease 0)
then mnove back to original tablespace, this is to avoid fragmentate your original tablespace, if it´s LMT then you can dmove the table in same tablespace




Reply With Quote