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

If multi log on parameter value is:1". one GUI user logged in one terminal, and same user id logged on other terminal as GUI, It will ask for Terminate a session if User selected to Terminate it will not to be terminated in SAP 

2 Answers   Willsys Technologies,

---

What will happen during the export process?

0 Answers  

---

I want to find all non executed transaction list (user wise) for last three months one option is through st03n but in that i have to find by each and every t-code there is any facility to get this list user wise

3 Answers  

---

IN FUNCTIONAL MODULE SD WE UNFORTUNETLY DELETE OUR ONE ITEM CATEGORY "TAN" FOR THAT WE WANT RECOVER IT WHAT ARE THE PROCEDURES. IS THERE ANY PROCEDURES LIKE RECYCLEBIN. TELL US DETAIL PROCEDURES STEP BY STEP PLEASE ARUN FROM SD

1 Answers   Wipro,

---

How to find expensive SQL statement, if found, what should be done?

3 Answers   Wipro,

---

How to see when were the optimizer stats last time run?

0 Answers   IBM,

---

can we prepare a landscape with ides systems?

3 Answers   Satyam,

---

where can i get the Dialog response time?

5 Answers   Satyam,

---

I am having develoment with 3 clients (100,200,300) and in PRD one client(500)after an year i purchased a new machine for quality so i want to import 2 clients (100,200) and in qas but i want the 100 client only sap_user and sap_cust profiles and 200 client sap_all only can i do that in quality any answers plz suggest me

2 Answers   IBM, Yash Technologies,

---

Tableau Training and Certification by Experts

0 Answers   SAP Labs,

---

How to find sap transaction codes?

2 Answers  

---

Why do you use DDIC user not SAP* for Support Packs and SPam?

0 Answers   IBM,

---