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
What are the different types of rfc and explain what transactional rfc is?
A transport is imported into QAS in 2 min. time the same transport when imported into PRD is taking more than 20 min. why? What to do?
Can you tell me installation procedure of SAP on UNIX
How to apply job on OS Level?
I also wanna work with Webdynpros? What are the requirements? I mean SAP 4.7 ee or ECC 5 or 6? Netweaver developer Studio? Also with win 2003 i have the activation problem every month. SO do i get a cd that doesnt ask for the activation? i have win 2000 but can it be installed on HP pavilion laptops that are coming preinstalled with Vista OS?
List the difference between asynchronous and synchronous transport?
what are the main issues you faced in the implementation project?
What are the different types of sap profiles?
Explain what are the functional modules used in sequence in bdc?
How should I set priority for Printing say like user, teamlead, project manager?
A user moved the transport request from dev to qua. How would you trace him?
What is the difference between st06 and st03?
if i want to limit the condition record validity for forst 10 orders how can i do tht plz ans i hve interview in 2/3 days
How would you troubleshoot the 'system seems slow'?
What is difference between oracle 9i and oracle 10g?