Oracle server running out of space
We have a linux(debian)server which has Oracle10g in it and it is running out of space now. So we decided to add some more disk space(adding a new hard drive in the same server). But if we want to add more data files how can I tell the DB to use the added disk space. Since all the data files are existing in /home/oracle/oradata/orcl and their tablespace (USERS) are in the old disk,is it possible to tell the DB to use the added disk.
Please let me know if that can be done and how.
Thanks in advance.