I have a third party application using Oracle 10g database with 1 tablespace and 1 datafile. They have assigned 10GB as the size of the tablespace which is almost full now. I know we can can increase size of this.
I want to clarify what if I add one more datafile and assign 10GB space to that? Do I need to modify anything on application or will it work normally?
So all I need to do would be:
alter tablespace USER_DATA_TBS add datafile '/oradata/ovbs/user_data04.dbf' size 1000m;
Please help, I am a total beginner.