Skip to Content
avatar image
Former Member

Move a data file from a file system for another

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 28, 2008 at 04:56 PM

    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

    Add comment
    10|10000 characters needed characters exceeded