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

How much swap memory should be in the system?

1017


Explain how client refresh is different than client copy?

1164


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?

1810


What are the errors you got while applying support pack?

1744


can u explain step by step procedure of DB REFRESH..Ravi

3690


What is osp$ mean?

1359


What is transport layer and domain controller? In which system you have create domain control?

1825


What is a developer key? and how to generate a developer key?

1061


What is a background processing batch scheduler?

1128


the difference between part number and serial number

3065


What is the different architecture between SAP 4.7EE & ECC5.0

2953


Explain what is heterogenous system copy and homogenous system copy ?

977


If any errors coming during transport where it will be recorded and how will you rectify?transport log and active log

2040


What is Unit Testing in SAP?

1195


Can you tell me installation procedure of SAP on UNIX

2335