Answer / 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

Answer / narayan

Yes ,we can move data file to other directory through
Brtools - space management - move data file - data file
name - current location - target location .

Answer / nishit jamuar

No , we can't change the location of existing datafile to
some other directory as control file will not be able to
locate that datafile in database open phase . Database will
not be able to find datafile. Controle file stores the
address of each and every datafile . If we will change the
the location of the datafile controle file will not
recognize it.

It is possible to change the location from exiting
directory only when we specify the new location for
datafile in Controle file

If a background job runs more than the time it should be completed normally then what action will u take ? Plz Post the Answer

5 Answers   AllState,

---

if saposcol service is not start? how can u troubleshoot?

5 Answers   Wipro,

---

What is table buffer and single record buffer?

1 Answers   IBM,

---

how to know whether a user in sap system is DIALOG or SERVICE user?

4 Answers   IBM, TCS, Wipro,

---

i am working with NBFC- MNC in personal loan dept. I applied for Internal Job Position in banking Division. My overall (10 years) experience in sales and People Management and in Internal Job Posting they require person for backend activity. There will be not repotees and its individual performance job. My Question is 1. If they will ask why you want to change your field form sales to backend job what should I answer? 2. The opening is in Chennai and since 10 year I am in Gujarat so if they ask why you want to change your home town location? Arpan Thakkar

0 Answers  

---

How can i get the currently loggedin user list.

3 Answers  

---

What are the activities you done in EP?

0 Answers  

---

Client export/ import pre-requisite?

3 Answers  

---

When support pack is stuck? What you do?

1 Answers  

---

How do set the alert monitors?RZ20.

1 Answers  

---

If you don't have authorization for executing suim tcode,how do you get user reports?can you access usr* tables in se16 without authorizations for suim?

2 Answers   IBM,

---

Apart from Update WP,which WP can also perform update in Database?? When we give print request, which WP comes into the picture??

4 Answers   ABC,

---