Printable View
I am sorry!!
What I would like to know that, suppose I don't know that some thing wrong has happened in my first disk.
And I try to move a datafile of a particular tablespace to a new location ...... U said I Oracle will fire an error.... My doubt is does oracle allow me to move that file at that time or it stop me there itself?
Regards
If you are trying to move a datafile to a new location when the database is up Oracle would retain the old location until you had physically move the file via a host copy command and in your senario this is where you would get the error but it would not be an Oracle error but an OS one.
eg.
To move a datafile while the database is open:
1. Make the tablespace READ_ONLY
2. Take the tablespace offline
3. Move the datafile via the OS --> this is where your error would occur.
4. Update the file location in Oracle
5. Bring the tablespace online
6. Make the tablespace READ_WRITE
Therefore if the error occured at point 3 and the file could not be moved it would remain in it's original location and you would simple skip point 4.
HTH
So, the error will occur at point # 3, bcoz of missing the controlfile right? Not for any other constraints.
Ok, I would like to clear one more doubt ....
1. Suppose I lost all my original control files, and Backup control files.
2. I am going to create a new control file with the details of existing datafile names and size.
3. I know the name but how to get the size of those files? Will u suggest me to take it from O/S level? but sometimes oracle give error even I am taking size from O/S.
What do u suggest?
Regards
Do we really need to put tablespace in READ ONLY=Quote:
Originally posted by jovery
To move a datafile while the database is open:
1. Make the tablespace READ_ONLY
2. Take the tablespace offline
3. Move the datafile via the OS --> this is where your error would occur.
4. Update the file location in Oracle
5. Bring the tablespace online
6. Make the tablespace READ_WRITE
And why?
It works without...