1. Can we change the data file location from existing directory?

1. Can we change the data file location from existing
directory?

Question Posted / raj

3 Answers
10449 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

1. Can we change the data file location from existing directory?..

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

1. Can we change the data file location from existing directory?..

Answer / narayan

Yes ,we can move data file to other directory through
Brtools - space management - move data file - data file
name - current location - target location .

Is This Answer Correct ?

7 Yes

0 No

1. Can we change the data file location from existing directory?..

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

More SAP Basis Interview Questions

Suppose you have to integrate sap ecc 6.0 to aws cloud. How can you achieve this?

0 Answers

EWA configuration?

1 Answers HCL, Wipro, Yash Technologies,

what are the phases in version upgrade from 4.7ee to ecc6.0

1 Answers IBM,

Hi Folks from SAP world, My name is herald and working in a distribution center. i graduated as an engineer so i got basic knowledge about programming languages. Just basic and very little in fact i almost forgot them but now i realize how important it is today. I am very interested to learn SAP and i actually big fat ZERO on it but i really want to learn. Does anyone want to give an advice how will i start? Please send your advice on my email. i really appreciate you time reading this specially the effort of giving me tips or advices. Cheers!

1 Answers

I am facing error at the time of background job(SAP_WP_CACHE_RELOAD_FULLStep 001 started (program RWP_RUNTIME_CACHE_RELOAD, variant SAP&RELOAD_ALL, user ID DDIC) No component system chosen Job cancelled after system exception ERROR_MESSAGE Step 001 started (program RWP_RUNTIME_CACHE_RELOAD, variant SAP&RELOAD_ALL, user ID DDIC) Message no. 00550 please help me with this

1 Answers IBM,

How to see the t able entry values?

1 Answers

How to add sap systems in solution manager? Steps?

2 Answers

Difference between SAPNote and Support package?

1 Answers

What is the difference between consolidation and development route ?

0 Answers

How to set the trace level for file dev_rd?

3 Answers

1.AFTER KERNEL UPGRADE IGS IS NOT WORKING WHAT SHOULD U DO ? 2.WHAT IS THE DIFFERENCE B/W USERTRACE AND BACKGROUND TRACE IN DATABASE? 3JSPM IS NOT WORKING WHILE APPLYING PATCHS WHAT COULD BE THE RESONS?

2 Answers Bosch,

A role is assigned to 100 users and for one day only 10 users need to be able to access that role and the other 99 users should not have access. How do you do that?

3 Answers IBM,

For more SAP Basis Interview Questions Click Here