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

From: Larry <larry1962_at_ureach.com>
Date: 4 Apr 2002 12:37:43 -0800
Message-ID: <a1238369.0204041237.6266b9df@posting.google.com>

I really need help! FAST!

I have some large tablespaces I need to move from a ufs file system to a new-and-improved veritas file system. We are out of space and I have to get this done. I followed the instructions to do this task...

shutdown
copy dbf files to new location (I didn't move the files...) startup mount
alter files '/v01/...' to '/v05/..'
alter database open

Problem is, when I run a query against a table that is in the relocated TS, the query just hangs. If I shutdown and put everything back the
way it was, the query works fine.

I am running Oracle 8.1.7.

Any thoughts? Received on Thu Apr 04 2002 - 14:37:43 CST