Move a data file from a file system for another

[Former Member]

Hi,

We have a file system that grows much more than the others. This is

because the higher tables are within that file system. We would like to

change some data files of that file system to another file system with

enough free space. NOTE SAP tried but did not find anything related to

this issue. There is some NOTE of SAP that recommends or suggests that this

exchange of making an appropriate way.

Thanks for the support.

Ricardo

[stefan_koehler]

Hello Ricardo,

1) shutdown your database

2) move your file from one filesystem to another on OS level

3) startup mount

4) alter database rename file '<OLD_FILENAME>' to '<NEW_FILENAME>'

5) alter database open

Regards

Stefan