I need some detail advise before I do defragmentation using exp/imp
1. coldbackup first
2. export all object in tablespace
3. drop tablespace
4. import data back with compress = Y
Could anyone give some details about step3 ->recreate tablespace-> step4
Did I miss any steps?
I don't have any free space for my TABLE tablespace now. Before defragmentation, do I need add 1 more datafile?
Please advise. This is kind of urgent.