[10.2.0.4] resize datafile
Hi,
I've got a lot of free space in my datafile (one datafile for one tablespace).
I want to reduce the size of my datafile.
Here are the steps I follow :
1) export tablespace (compress=n) => dump
2) drop tablespace
3) create tablespace
4) import full of my dump
Did I forget something ?
Rgds,
Frederic
I want to reduce the size of my datafile.
Here are the steps I follow :
1) export tablespace (compress=n) => dump
2) drop tablespace
3) create tablespace
4) import full of my dump
Did I forget something ?
Rgds,
Frederic
0