Re: File System question

"Jay" <jlee00_99_at_yahoo.com> wrote in message news:3ea71bf0.0308181428.745a805_at_posting.google.com...
> I have 480 blocks of space left on a File System. On this file system
> is an installation of Oracle DB. I have been running out of space on
> this particular file system. I have removed some log files to free up
> space, but this hasn't helped much at all. I know I can
> unmount/remount this file system to allocate more space, but I think I
> will have to reinstall Oracle DB, which is not the ideal choice. I
> will most likely reduce the size of database files (dbf files) to free
> up additional space. Other than error messages indicating that the
> file system has no free space, what other issues will I encounter if
> significant amount of space is not freed up?
>
> On a side note, I do have significant amount of space on other file
> systems on this Uniware 2.X box.

Database could freeze if you are in archive log mode. Chance are it will mess us.

Why do you say you will have to reinstall Oracle DB, why are the dbf on the same filesystem as the Oracle binaries?

You could move all the datafiles to the file systems where there is space. Doesn't seem like you need to rebuild anything, just do a little management.

Dont forget you can also resize your datafiles to make them smaller if they are too large Received on Mon Aug 18 2003 - 17:32:09 CDT