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

Transport request types and its syntax?

1995


What is JVM switch. Why JVM switch is required ?

2172


What is the system's configuration required to implement SAP.

892


Explain what is sap ides?

655


How would you troubleshoot the 'system seems slow'?

655






Explain what are the functional modules used in sequence in bdc?

601


If a background job runs more than the time it should be completed normally then what actions will u take?

1361


Which transport directory is used to implement support package and add-ons?

640


What is your UNIX experience and the types of UNIX systems you have worked on.

1591


what is netweaver

1113


On a particular system how you can get a list of the users with development access on a particular system?

657


How will you define logon groups ? What is load balancing in sap ?

613


How to setup RFC connection in ecc6 tells me steps involved?

1705


does the Tcode EWZ5 exist in ECC6?I'm using NW2004S SR2 abap engine and EWZ5 doesn't exist in that.so in that case what is the alternative to EWZ5?to see the list of users present in a client but not necessarily logged in and to to lock or unlock them? Thanks.

3433


Explain what is business kpis ?

636