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
How much swap memory should be in the system?
Explain how client refresh is different than client copy?
A transport is imported into QAS in 2 min. time the same transport when imported into PRD is taking more than 20 min. why? What to do?
What are the errors you got while applying support pack?
can u explain step by step procedure of DB REFRESH..Ravi
What is osp$ mean?
What is transport layer and domain controller? In which system you have create domain control?
What is a developer key? and how to generate a developer key?
What is a background processing batch scheduler?
the difference between part number and serial number
What is the different architecture between SAP 4.7EE & ECC5.0
Explain what is heterogenous system copy and homogenous system copy ?
If any errors coming during transport where it will be recorded and how will you rectify?transport log and active log
What is Unit Testing in SAP?
Can you tell me installation procedure of SAP on UNIX