adding datafile

[learn]

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

[pwoneill]

It won't automatically be named work1.dbf you would have to do that manually.

alter tablespace work offline;
host cp /u04/Ora06/d_dtafile/work.dbf /u04/Ora06/d_dtafile/work1.dbf
alter database rename datafile '/u04/Ora06/d_dtafile/work.dbf' to '/u04/Ora06/d_dtafile/work1.dbf'
alter tablespace work online;

Once you're sure it's running you should be able to just remove work.dbf

[sysdba]

After you add more datafiles into a tablespace, your
original data file names will NOT be changed automatically.