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
Explain what is sap ides?
When we are doing cash sales, free goods and discount, How many pricing procedure do we need to create..? Only one PP required or have to create multiple PP..? and how many condition type we need to create..?
Explain deletion flag?
How do I know what threshold values to set
what is the procedure for java stack upgradation?
Can anyone help me in educating me in installing SAP 4.6C over windows server 2000. Please make it a step by step process, my career depends upon the success and failure of installation.
How to do transport at OS level?
What is MySAP?
What are the regular activities u do in solution manager and how
Where do you download trail version of sap ecc, what is sap cal?
What is you allocate disks to different areas in sap?
How to check CPU usage in EP? If java path is down the how to do trouble shoot? What is the transport group? What is the SLD system in PI? How to take back up in EP? How to create logical system? Is it possible to change the name logical system in SSC4? How you will take the online Backup and incremental Backup? What is the backup strategy? How many application servers you have in Production System? Difference between oracle 9i and oracle 10g? What is EHP4? What is your enhancement package and support package? how to find RAM size on Unix? How to find OS level at command Prompt? While doing kernel upgrade what is exe files? What is client comparison? How to apply job on Os level? What are the recent challenges faced? How to apply support package in solution manager? Difference between SPDD/SPAU If SAP* is not working ? If job is slow? how you will trouble shoot? What are software files required for SAP 4.7?
What are saplpd and tcp/ip print server and purpose? And difference b/w saplpd and tcp/ip print server?
What is the different type of users in sap?
What are the different types of job status? Can you unschedule an active job?