Re: moving the rbs tablespace

Did you do these steps? My guess is you forgot to do the alter database step...

1. shut down the instance
2. use OS commands to move the data file
3. mount the database (use svrmgrl, connect internal, startup mount <dbname>
4. still in svrmgrl, use ALTER DATABASE RENAME FILE '/old/file/name' to '/new/file/name'
5. alter database open

Tom Best

loumaus_at_my-deja.com wrote:

> is there a short description on howto move the whole rbs-tablespace on
> a working server....
>
> i tried to do so but when reactivating the rollbacksegemnt ( putting it
> online ) the server echos "error changing datafile status ora-01113
> file 2 needs media recorvery"...
>
> of course the rbs-segemnts were set offline to move the tablespace
>
> i would appreciate any help
>
> thanks
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Nov 23 1999 - 08:52:52 CST