How to view the free space from one tablespace
How to view the free space from one tablespace
You can view the tablespace free space using the statement below:
SQL> SELECT TABLESPACE_NAME, FILE_ID, BYTES
2 FROM USER_FREE_SPACE
3 WHERE TABLESPAE_NAME IN ('USERS', 'MY_SPACE');