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
Where can you find a list of object keys included in a transport?
Explain what is luw (logical unit of work)?
how can i change access to a user who is having access for SPRO display only to change access in sPro
When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?
Is there a difference between user ddic and sap_all/sap_new?
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?
Mention what is the difference between sdm and jspm?
What are the key activities that you perform as part of sap basis support?
How can you define login policy for users in sap system?
What is XI3.0? Explain XI
Mention what is the difference between central instance & application server?
Is there any report or table in which user log off time is stored in sap?
What are patches you applied?
Does any one have SAP basis B1 Resume format for 4 to 5 year experience? if any one have please send me on kishorekharche@gmail.com
what is the procedure for java stack upgradation?