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 are the types of tranports?

3 Answers  

---

you want to take sap backup using brtools. How would you do that?

0 Answers  

---

how to find whether the operating system is 32bit or 64bit in SAP Level and O/S Level?

7 Answers  

---

How to unlock the user in os level?

4 Answers  

---

How can you find the list of objects that have been repaired in the system?

0 Answers  

---

Why https is considered safer than http?

6 Answers  

---

As per your process, Lets say someone asked you access for SAP_ALL and you got approval from the business head to assign but you did not get approval from the Security head. In this case, what will you do?

1 Answers   Infosys, Spine Infoway,

---

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

12 Answers  

---

When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?

0 Answers  

---

What are the steps to configure TMS?

6 Answers   Cap Gemini,

---

when i did run cccleaner, i had lost my sapmmc console tree.i can see sapr/3 system option under console root.so i am not able to start my server.how can get resolve of this problem. please any one suggest get rid outoff this.

5 Answers  

---

What is WF and its importance?

1 Answers  

---