Hello all,
We finished upgrading the database to 11.2.0.4 using the upgrade assistant two days back. The database is up and running. I checked the tablespaces and the datafiles using enterprise manager console. The Space used by every data file is almost 96-98%. We have all the files located in our D drive. We have a lot of space on the D drive..approximately 100GB available. I would like to resize all the tablespaces and give some extra room for the data to grow. I have never done this before and since it is a production system, I want to be more careful and get some advice to do it in the right way. I have a few questions.
I plan to run the following command:
ALTER DATABASE DATAFILE 'd:\oradata\stuff01.dbf' RESIZE 1G;
1) Can the database be open when I execute this command or do I need to put it in mounted state?
2) Do I need to run this command during off-hours only or I could run it at any time.
3) Is there anything else I should take care of before I execute this command and resize the datafiles?
Thanks.