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

Mention what is the difference between central instance & application server?

866


Is sap a database ?

868


does the Tcode EWZ5 exist in ECC6?I'm using NW2004S SR2 abap engine and EWZ5 doesn't exist in that.so in that case what is the alternative to EWZ5?to see the list of users present in a client but not necessarily logged in and to to lock or unlock them? Thanks.

3714


What is the difference between kernel replacement and support package?

933


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?

1643


1.how to retrive corrupt file in back up ? 2.what post actives of patching 3.how increase the file size in unix

1785


Explain what are the functional modules used in sequence in bdc?

846


the difference between part number and serial number

2801


Hello Guys, If any body looking for "SAP Vendor Invoice Management (VIM) Training", Please Contact Me,We will covers all SAP VIM topics along with end to end ICC, Document pipeline xECM, Enterprise scan etc. Email ID :kakumanusasikanth@gmail.com

1528


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

3000


What are the activities you done in PI?

2801


How would you troubleshoot the 'system seems slow'?

839


What are the different types of sap profiles?

816


What is the different type of users in sap?

871


what are the main issues you faced in the implementation project?

1797