Re: Relocating native OS file for a tablespace?

From: L120bj <l120bj_at_aol.com>
Date: 1997/02/23
Message-ID: <19970223123501.HAA14995@ladder02.news.aol.com>#1/1

Subject: Relocating native OS file for a tablespace? From: "Tim Romano" <tim_at_ot.com>
Date: 9 Feb 1997 16:56:56 GMT
Message-ID: <01bc16aa$69d55010$86f0eac7_at_haven> You don't have to edit any configuration files. First do a full offline backup of your database just in case Next COPY the files to the new location, DO NOT move them. Then you have to login to the database in sqlplus/svrmgrl with DBA permissions and issue an
alter database rename file '....','.....','.....' to '.....','.....','.....'
command
Once this has completed issue
alter database backup controlfile to 'control.bak.970223' the filename should be unique with the ORACLE_HOME/dbs directory This is just in case of media failure before the next clean shutdown If you now issue
select tablespace_name, file_name from sys.dba_data_files you should see that the new file name are being used. You should now be able to delete the original files, although you may need to shut ORACLE down first.

---

---

I have three non-system tablespaces (e.g. MY_DATA, MY_TEMP, and MY_RB) whose underlying native OS files I have to move. (I am running Personal Oracle for Windows NT 7.2.2.4). These files are now in D:\ORADATA and I would like to move them to E:\ORADATA. Which Oracle configuration file(s)
must I modify to point to the new location? MY_RB contains a couple of public rollback segments.

Thanks in advance,
Tim
please cc; me at tim_at_ot.com if you respond to the group. Received on Sun Feb 23 1997 - 00:00:00 CST