I guess what shrutiM is talking is use show=Y option while imprting which give you all the definitions of the objects where you can search for TABLESPACE string and edit.

For small databases/schemas it works, otherwise its time consuming and mistake prone task cuz, Iam doing it now for a test database to be resized by 1/10th of production. and I hate to do it... but, didn't find any alternative.

Otherwise, if you have enterprize manager, import with rows=n option and reorganize the schema/tablespace. It will not take that long as its only objects and there is no data. Then import data with rows=y after reorg.

[Edited by sreddy on 01-04-2001 at 09:55 AM]