The following two methods can be used:
1. Add a data file for this table space SQL> ALTER TABLESPACE Table Space Name Add DataFile '/u1/oradata/UserData_002.oradata/UserData_002.ora' size 50m; --unix SQL> ALTER TABLESPACE Table Space Name Add DataFile 'C: / ORADATA / uSERDATA_002.ORA 'SIZE 50M; - Windows NT
2. Re-adjust the size of the data file SQL> ALTER DATABASE DATAFILE '/U1/Ordata/UserData_001.oradata/UserData_001.ora' resize 50m; --unix SQL> ALTER DATABASE DATAFILE 'C: / ORADATA/USERDATA_002. ORA' Resize 50M; WINDOWS NT
----------------
Q: How do we increase the size of the table space in the Oracle database? A: In the development of the Oracle database, we have two ways to increase the size of the table space:
1. Increase additional data files to table spaces, for example: alter tablespace users add datafile '/u01/oradata/orcl/users02.dbf' size 25m;
2. Modify the current data file of the table space, for example: alter database datafile '/u01/oradata/orcl/users01.dbf' Resize 50M;
