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

How you will do client copy?

1 Answers  

---

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

0 Answers   Fujitsu,

---

Hi , Can any one tell me , How to take back up to local disk . And also tell me where i need to change the parameters to take back up , please give me the list of parameters and appropriate values. Please provide me the steps to take back up.......

2 Answers  

---

what is role of sap administrator in pi & ep?

3 Answers  

---

What is the importance of the clients 000,001 and 006?

4 Answers  

---

What is a developer key? and how to generate a developer key?

0 Answers   IBM,

---

What are the transport routes?

2 Answers  

---

How to import mass transport request ? Expalin me the procedure and draw backs:?

4 Answers   Fujitsu,

---

Applied basis support pack successfully when the system which is not updated in the system status? Why? How to resolve?

1 Answers  

---

how can i change access to a user who is having access for SPRO display only to change access in sPro

0 Answers   BAL,

---

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  

---

How can I restrict the user from printing?

0 Answers   IBM,

---