on 07-30-2007 8:10 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.