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

Have you done any up gradations?

0 Answers  

---

what is the difference between se16 and sm30?

1 Answers  

---

Which program is used to check whether partner profiles are consistent?

1 Answers  

---

How do you create control file? What is the command?

3 Answers   HCL,

---

What are steps for DB Refresh?

0 Answers   Anmol Biscuits, BAL,

---

---

What is Consolidation route and delivery routes? How you will identify them?

1 Answers  

---

How to do MS SQL Server upgrade 2005 to 2008 .IF ANY ONE HAVE SCREEN SHOTS PLEASE UPDATE ON ppsr_reddy@yahoo.com

2 Answers   Wipro,

---

what is the use of Zlayer and saplayer in tms

3 Answers   HCL,

---

Can a Patch be rolled back in ABAP or Java?

5 Answers  

---

What is early watch report?

3 Answers  

---

What is the difference between kernel replacement and support package?

0 Answers  

---

If Background job active long time ?

3 Answers  

---