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

what is the full name of SAP Default user DDIC

8 Answers   DS Group, HCL,

---

What is upgrade process? And how u will do that?

0 Answers  

---

How many transport request types are there? Plz Post the Answer if u know thanks & regards Dev

12 Answers  

---

After Installation of the SAP software, its giving posting period 2004. I am not able to make it to 2009 financial year.. how we make it.. what are the activities we have to do ?

1 Answers  

---

What is the procedure to delete a client?

4 Answers  

---

what is the difference between sap lock and data base lock?

1 Answers   Accenture,

---

What is password policy?

0 Answers  

---

how can we create a particular tables buffer which are mostly used/ And where we can see them ?

1 Answers  

---

User has scheduled a Background Job, he wants that background job to run faster. How to speedup the background job process?

2 Answers   Cap Gemini, Wipro,

---

you want to do a system-copy. List the steps you will take.

0 Answers  

---

What are various profiles available for client copy?

1 Answers  

---

If the server buffer memory reaches 95% of memory what will will be the measure have to take for solve that issue.

1 Answers   Accenture, TCS,

---