Oracle - [ Alter Database Datafile ]

 1* select file_id,file_name,bytes/1024/1024,maxbytes/1024/1024 from dba_data_files order by file_id
SQL> /

   FILE_ID FILE_NAME  BYTES/1024/1024 MAXBYTES/1024/1024
---------- ------------------------------ --------------- ------------------
1 +DSKDATA/oralee/datafile/syste      740  32767.9844
  m.334.783430381

2 +DSKDATA/oralee/datafile/sysau      810  32767.9844
  x.335.783430383

3 +DSKDATA/oralee/datafile/undot      815  32767.9844
  bs1.336.783430385

4 +DSKDATA/oralee/datafile/algor     4000 8000
  .338.783430389

5 +DSKDATA/oralee/datafile/algor     4000 8000
  _indices.339.783430395

6 +DSKDATA/oralee/datafile/undot      200  32767.9844
  bs2.340.783430401

7 +DSKDATA/oralee/datafile/users   161.25  32767.9844
  .341.783430401

SQL> alter database datafile 1 autoextend on next 500m maxsize 8000m;

Database altered.

SQL> alter database datafile 2 autoextend on next 500m maxsize 8000m;

Database altered.

SQL> l

  1* alter database datafile 2 autoextend on next 500m maxsize 8000m

SQL> c/2/3/

  1* alter database datafile 3 autoextend on next 500m maxsize 8000m

SQL> /

Database altered.

SQL> c/3/4/

  1* alter database datafile 4 autoextend on next 500m maxsize 8000m

SQL> c/4/6/

  1* alter database datafile 6 autoextend on next 500m maxsize 8000m

SQL> /

Database altered.

SQL> c/6/7/

  1* alter database datafile 7 autoextend on next 500m maxsize 8000m

SQL> /

Database altered.

SQL> set pages 120

SQL> set lines 100

SQL> column file_name format a30

SQL> /

   FILE_ID FILE_NAME  BYTES/1024/1024 MAXBYTES/1024/1024

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

1 +DSKDATA/oralee/datafile/syste      740 8000

  m.334.783430381

2 +DSKDATA/oralee/datafile/sysau      810 8000

  x.335.783430383

3 +DSKDATA/oralee/datafile/undot      815 8000

  bs1.336.783430385

4 +DSKDATA/oralee/datafile/algor     4000 8000

  .338.783430389

5 +DSKDATA/oralee/datafile/algor     4000 8000

  _indices.339.783430395

6 +DSKDATA/oralee/datafile/undot      200 8000

  bs2.340.783430401

7 +DSKDATA/oralee/datafile/users   161.25 8000

  .341.783430401

7 rows selected.