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
can u explain step by step procedure of DB REFRESH..Ravi
Explain domain controller?
How many types of work processes?
I have a requirement from the SD people wherein whenver one runs the tcode F-02 (Enter G/L account Policy : Header Data), they should not get the list of all acounts in the ACCOUNT field. But when i go to pfcg to check for restricting the list, i dont find any pertinet auth field for doing so. Isi t something that we can ( as Basis Admin) do or the ABAPpers to do. Maybe the ABAPpers have to program the screen where in they need to restrict the list options. If not so, lemme know the auth field that has to bet set if any.
If client copy is stopped in middle, what happens if you want to start it again?
What is the role of “ application server” ?
what is role of sap administrator in pi & ep?
What are the Parameters need to be set when connecting EP to r/3 system what are they?
can anyone tellme java instance startup sequence?
Hi i have 2.10 yrs of experience on Sap Basis...been working as a sap basis consultant.but unable to get through MNC companies...On what criteria does HR select the candidate.does my academics matter coz they are not good thou i am a B.tech graduate
Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?
How to deactivate IPC in standalone CRM.
how to do system refresh?not the client copy but the-standard-system-refresh.
what is sox and sod in sap ?
How can you find the list of objects that have been repaired in the system?