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


Please Help Members By Posting Answers For Below Questions

What is client administration in sap system? Why do we use multiple clients in sap system?

978


Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.

2445


Example you have 6 sap application servers, I want to monitor all the application servers. How to configure a CCMS?

3027


When we install sap r/3 enterprise 4.7, there are several error messages in the sapview.log. What does this mean?

987


What is the database backup strategy in your company?

2016


What is the purpose of webdisptcher and Installing and configuring Web Dispatcher what are the prerequisites?

2253


how can i decleare select-options in module pool table control?

3402


what is your project architecture?

1875


Explain kernel upgrade?

842


What are the errors you got while applying support pack?

1611


Difference between system refresh and client copy?

2590


How you connect ECC to EP?

1841


In the Sap Easy Access Menu I see the menu System -> User Profiles ->Own Data. Other options Hold Data is to keep data values that you have entered in a field of an application for the duration of the session; SET DATA not to overwrite the data and DELETE DATA to delete the set data. Can somebody explain me the Hold Data, Set Data and Delete Data with examples, i mean giving an example of fields?

3630


What will happen during the export process?

1820


Explain the system trace?

883