cancel
Showing results for 
Search instead for 
Did you mean: 

Move datas to another sap datafile directory

Former Member
0 Kudos

Hi there,

I want know the exact sql query which will move sap datafiles from one directory another directory.

Example. Currently we have sapdata 1...12, and we added another file sapdata13 and some of the sapdata 1..12 are too full and I would like to move few of the big datas from sapdata 1...12 to sapdata13

I am using Unix, Oracle 10g. and these sapdata1..13 are mount points.

Example:

I have this

/oracle/SID/sapdata11/<b>btabd_35</b> , which holds 5GB

and I want to move this btabd_35 to /oracle/SID/sapdata13/ directory?

can someone tell me exact sql query that will do this?

Thanks in Advance

Kumar

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi,

You have several options.

If I'm not wrong all documented on the SAP note 868750 "How to relocate/rename a datafile"

Note that a SQL query will NOT move physically the files.

Former Member
0 Kudos

Thank you so much. That is what I wanted.

Answers (0)