Re: .dbf files on external USB disk - doable?

"OtisUsenet" <otis_usenet_at_yahoo.com> wrote in message news:5606b639.0406021609.34626ed5_at_posting.google.com...
> Hello,
>
> My Oracle database needs more disk space than I have available on my
> work station, and I am considering hooking up an external disk with a
> USB interface, and moving all Oracle data files there.
>
> Has anyone tried this? Are there any issues with this that one should
> be aware of?
>
> I am planning on simply mv-ing the files and then sym linking to them
> from the usual /u01 and /u02 locations. Will this work?
>
> Any advice would be greatly appreciated.
> Thank you.
> P.S.
> I'm not very concerned with performance, this is only for development,
> but I would like to avoid data corruption and such.

It can be done. But I wouldn't do it. It would be far better to upgrade the hard disk inside your workstation.

That is, if this is in any serious sense a database. I know you say you don't particularly care about performance, but that's only one of the issues. Performance will be poor, even at USB2.0 speeds. But the real worry is what happens when your USB cable gets pulled out, or the power supply to the external device is accidentally removed. I know Oracle has recovery mechanisms, but unless you're planning on testing them to their limits, I wouldn't risk it.

So as I say: although this is 'only for development', if you actually care about the database, and it's not actually disposable, I would be getting a nice new fat hard disk for my workstation, and not going down this particular road.

Regards
HJR Received on Wed Jun 02 2004 - 19:17:22 CDT