Re: URGENT: Need to move TS from ufs to vxfs file system

Howard et. al.,

Thanks for the feedback.

1. I mistyped my note. I ran this command: alter database rename file 'xxxxx' to 'yyyyy'.
2. To "undo" what I did, I did NOT need to copy or move the file back (at the OS level). It was still in the original location. But I did use the alternate technique of taking the TS offline, and changing the filename back that way so as to keep the instance online. Once done, I could query the tables in that TS again.
3. I tested this TS relocation scenario with a play TS and a simple three row table. It worked just fine when I copied the datafile to the veritas file system. So I figured I was good to go with my real TS. Only difference is that my real TS supports an Intermedia (CTX) database. But isn't a database block just a database block, regardless of what is in it?
4. My Oracle blocksize is 8192. UFS uses a blocksize of what, 512? Veritas uses something different from ufs. But I've been told this doesnt matter, since Oracle is concerned not about the file system blocking, but the internal blocking.
5. Is it OK to COPY the datafile, as opposed to MOVE the datafile? Is there any real difference. I mean, a unix cp command creates an exact copy, right?
6. Oh yes. I did verify everything by checking the file names in the v$datafile view.
7. File permissions. I checked. Both the original and the copied datafiles have the same unix rwx permissions. Both are owned by the oracle account.

Any thoughts?

Thanks to all,
Larry Received on Thu Apr 04 2002 - 21:10:44 CST