First of all, A tablespace is the logical storage unit in Oracle Database and may consist one or more datafiles. If you found your USR table capacity to be 99.7% (good Luck!) then you might want to increase the tablespace where the USR table resides. How do you do that?
ALTER DATABASE DATAFILE '/directory/path/file_name.dbf' MAXSIZE 500M ;
That command simply increased the existing tablespace that you have. But if you want to add another datafile to the tablespace in which your table resides you may issue this command:
ALTER TABLESPACE your_ts_name ADD DATAFILE '/directory_path/file_name.dbf' SIZE 200M AUTOEXTEND ON MAXSIZE 500M;
as simple as that….
