1. Can we change the data file location from existing
directory?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what are the pre-requisites to apply support patch?
database is not connected what type of errors can we expect? trans.log file where its store? errors format?
once a request is imported,is there any way to undo it? how about version management?
What will you do when you cannot login to a dialog server?
What are Homogenous system copy and Heterogeneous system copy and how you will do that?
Mention what is the purpose of table usr02?
How to handle the situation where-in SAP isn't available?
what is the main difference between remote client copy, and client export and import.
How to setup RFC connection in ecc6 tells me steps involved?
How do find the SNOTE?
Where is the Deletion Flag or Indicator used in archiving process?
what u mean by check point in the database of oracle& what return code 247 in TMS mean...