1. Can we change the data file location from existing
directory?
Answer Posted / arif
You can change the datafile location by using BRTOOLS (
rename datafile) or oracle level command "ALTER DATAFILE
RENAME 'datafile absoulate location' TO " Target Location'.
Prerequsite
1. take the datafile offline
2. copy it to new location
3. submit command
4. remove old file
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Explain transport domain?
Explain checkpoint?
What is “data sets” in sap?
Which are the most frequent errors encountered while dealing with transports ?
What is business kpis ?
How you can assign an object to 100 roles at time?
How to perform a sap-export and import tables in sap from os level?
what is the common storage file for oracle ?
in oracle script @? "?" question mark means what it indicate?
you want to take sap backup using brtools. How would you do that?
What is the use of patches in sap system? Could you name few common patch types?
What is the difference between Party & Service without party in XI (ID)?
what are the main issues you faced in the implementation project?
Difference between system refresh and client copy?
Do? If another user wants to share that lock but the user using that