1. Can we change the data file location from existing
directory?
- 3 Answers
- 10432 Views
- IBM, I also Faced
- E-Mail Answers
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
How can I restrict the user from printing?
what can we do if shadow instance is down and getting up in prepare phase of upgrade
How u will give new authorizations?
What is R/3? and what is basis version?
Where is the Deletion Flag or Indicator used in archiving process?
How to update SAP
While doing implementation do you get any issues?
What is the difference between developer trace, system log and system trace?
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 you have a long-running Job, how do you analyse?
Explain reference and service user in sap. What are their uses?
How do you kill a job in SAP?
How will go about doing a client copy ?
What are steps for DB Refresh?
What are the pre requisite for the SAP Installation?
