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

According to the DBA handbook the steps are:

1. Do not shut down the database
2. Take the tablespace off-line
3. Move the datafile(s)
4. Use the ALTER TABLESPACE command to rename the file within the database
5. Bring the tablespace back on-line.

This does not correspond with what you did.

Reference: Oracle 8i DBA Handbook, Loney & Theriault, pg 138.

Daniel Morgan

Larry wrote:

> 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 - 15:11:30 CST