If I use the tabespace approch for moving table from one tablespace to another then is it required to truncate all schema tables.

Please make your comment on it.


Quote Originally Posted by PAVB
If the whole idea is to reorg these tables...

May I suggest:
1-- Export whole schema
2-- Truncate all schema tables
3-- Coalesce tablespaces
4-- Import fromuser/touser skip=y