1. Can we change the data file location from existing
directory?
Answer Posted / 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
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
At o.s level where to check for system logs of sap application?
What is private mode? When does user switch to user mode?
What is the different type of users in sap?
Where will you change the parameters in three profiles?
How can I restrict the user from printing?
What are the Pre- requisite for system copy?
User wants lock ASAP then what will u do?
Explain how to define logon groups?
Do you know logon groups at which situation will be created logon group?
How to analysis abap dumps?
What is the information derived from OSS notes?
Explain the system trace?
Which are the most frequent errors encountered while dealing with transports ?
What is the purpose of tdevc ?
If I want only transaction data to be copied.What profile should I select, while doing local client copy within the same apllication server. Else is there any other way to perform above task?