-
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
-
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
-
After you add more datafiles into a tablespace, your
original data file names will NOT be changed automatically.
