Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

At o.s level where to check for system logs of sap application?

998


What is private mode? When does user switch to user mode?

1121


What is the different type of users in sap?

1041


Where will you change the parameters in three profiles?

1141


How can I restrict the user from printing?

1043


What are the Pre- requisite for system copy?

1774


User wants lock ASAP then what will u do?

1862


Explain how to define logon groups?

1033


Do you know logon groups at which situation will be created logon group?

1193


How to analysis abap dumps?

1055


What is the information derived from OSS notes?

7039


Explain the system trace?

1044


Which are the most frequent errors encountered while dealing with transports ?

1239


What is the purpose of tdevc ?

1400


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?

6736