RESIZING DATAFILE IN ASM

• Re-sizing  datafiles in ASM is very simple.

SQL> select name from v$datafile;

NAME

--------------------------------------------------------------------------------------------------------------------------

+DATA/ieclive/datafile/system.258.860628911

+DATA/ieclive/datafile/sysaux.264.860628911

+DATA/ieclive/datafile/undotbs1.262.860628913

+DATA/ieclive/datafile/users.259.860628913

+DATA/ieclive/datafile/undotbs2.269.860629051

+DATA/ieclive/datafile/users.256.860630027

+DATA/ieclive/datafile/users.274.860630073

7 rows selected.

SQL> alter database datafile '+DATA/ieclive/datafile/system.258.860628911' resize 5g;

Database altered.

SQL> alter database datafile '+DATA/ieclive/datafile/sysaux.264.860628911' resize 5g;

Database altered.

Happy Learning …..