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

could u explain the transport steps (step by step) procedure?

11 Answers   IBM, TCS,

---

How can users be transported between different clients?

2 Answers  

---

Why dont we apply patche like Transports? (DEV--->QA-->PRD)

2 Answers   CTS,

---

How to apply note in SAP if SNOTE transaction doesn't exists?

2 Answers   IBM,

---

What is sap single stack system?

0 Answers  

---

---

Can anyone help me in educating me in installing SAP 4.6C over windows server 2000. Please make it a step by step process, my career depends upon the success and failure of installation.

2 Answers  

---

Explain what is heterogenous system copy and homogenous system copy ?

0 Answers  

---

How to know whether a system is Unicode or non Unicode?

9 Answers  

---

What is the sequence order of instance profile?

1 Answers  

---

Difference between init.ora and listener.ora?

1 Answers  

---

when performing client copies what steps you need to take from CUA point of view?

2 Answers   iGate,

---

what are the sap table space names that you see in db02?

3 Answers   iGate,

---