Re: How do I relocate my Database?

In article <2n07nd$ma5_at_ionews.io.org>, elfman_at_ionews.io.org (Peter Scheffler) wrote:

>
> Hiya'l.
>
> This week, I needed to reorganize my office machines. I had a 486 with 2-1G
> drives running DOS/Oracle 6. Everything was fine. Those drives were local
> because we didn't have room on our 3 Banyan Servers for more disks (we are
> getting a four in our office.) Why I reorganized is because I have now added
> to new draftspeople to my team, and they need to see the drawings at all times
> which are available on these drives. So I move my drives onto my other
> computer which is running Windows NT and took the 300 Megs off of the NT
> machine and put those in my PC.
>
> Still fine..... but, now my database thinks that it is on my C-Drive when I
> start it up, but it isn't, its on my NT drive available through my WFWg 3.11
> network!! So I can't start up Oracle!! Can anyone tell me how to tell Oracle
> that the Database isn't in C:\ORACLE6\DBS, but in O:\DBS? I tried using
> ALTER TABLESPACE tbs RENAME DATAFILE ....
> but that didn't work.

So you didn't try
  ALTER DATABASE RENAME FILE 'filname_old' TO 'filename_new' ; didn't you ?

>
> Thanx in advance,
> Peter Scheffler
> Hexolusions, Inc
> Scarborough, Ont
> elfman_at_io.org

This should do the trick as I have moved my database files on a Sun from a raw partition in a cooked filesystem.

Hope this helps
LM

-- 
Leo Mannhart
Planning Office
University of Zurich               phone: ++41 1 257 23 34
Kuenstlergasse 15                    fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland        eMail: mannhart_at_zuv.unizh.ch