Hello people,
My tablespace is running out of space so I have decided to add nother datafile.
My original datafile looks like this:
/u04/0rac06/d_dtatfile/work.dbf

After I have added another datafile e.g.
/u04/0rac06/d_dtatfile/work2.dbf.

Is the first datafile going to look like
/u04/0rac06/d_dtatfile/work1.dbf automaticaaly after I have added the second datafile or I have to manually change it to look like this /u04/0rac06/d_dtatfile/work1.dbf instead of this
/u04/0rac06/d_dtatfile/work.dbf

The reason why I am asking is that I want both datafiles to look like this:
/u04/0rac06/d_dtatfile/work1.db
/u04/0rac06/d_dtatfile/work2.dbf


still learning,
learning