Re: Moving log Files to new Drive

There's no parameter. You have to add new log files to your server. Then, you can drop the old log files. Because you cannot drop a log file that's currently in use you have to apply the command alter system switch logfile to free th current logfile if you want to drop it. You have to delete the log files after the procedure with your operating system utilities. 1.
alter database add logfile group 4 ('...') size 10M; alter database add logfile group 5 ('...') size 10M; 2.
select group, status from v$log;
3.
alter system switch logfile;
Repeat until status = current on group 4; 4.
alter database drop logfile group 1;
alter database drop logfile group 2;

In article <3563183700000013_at_news.accincy.com-MINC>,   "Matthew D. Heilman" <matthew.d.heilman_at_ac.com> wrote:
>
> I am running out of room of one of my drives. I would like to write all my
> log files to another drive. Is there a parameter I can change to do this?
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri May 22 1998 - 01:04:46 CDT