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 / arif

You can change the datafile location by using BRTOOLS (
rename datafile) or oracle level command "ALTER DATAFILE
RENAME 'datafile absoulate location' TO " Target Location'.
Prerequsite
1. take the datafile offline
2. copy it to new location
3. submit command
4. remove old file

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain transport domain?

983


Explain checkpoint?

1023


What is “data sets” in sap?

1141


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

1299


What is business kpis ?

1065


How you can assign an object to 100 roles at time?

1427


How to perform a sap-export and import tables in sap from os level?

1297


what is the common storage file for oracle ?

2101


in oracle script @? "?" question mark means what it indicate?

2376


you want to take sap backup using brtools. How would you do that?

1161


What is the use of patches in sap system? Could you name few common patch types?

1187


What is the difference between Party & Service without party in XI (ID)?

2355


what are the main issues you faced in the implementation project?

2038


Difference between system refresh and client copy?

2829


Do? If another user wants to share that lock but the user using that

1741