RE: where to alter the path of redologs

From: Wasserman, Sara <sjwasserman_at_pscnet.com>
Date: Mon, 10 Jul 2000 08:13:01 -0700
Message-Id: <10554.111545@fatcity.com>

Rachel, this seems like extra steps to me. What's wrong with:

1. create a new redo log file(s)
2. switch logs until you are in the new log file
3. drop the old one(s)

Is there a reason you need a temporary file?

Arvind,

To answer your second question: You can't control which tables in a tablespace go into which datafiles in a tablespace. If you want to separate tables, you'll need to place them in separate tablespaces.

HTH,
Sara Wasserman

> -----Original Message-----
> From: Rachel Carmichael [SMTP:carmichr_at_hotmail.com]
> Sent: Saturday, July 08, 2000 9:04 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: where to alter the path of redologs
>
> if you can't take the database down:
>
> 1. create a new, temporary redo log file
> 2. switch logs until you are in the new log file
> 3. drop the old one
> 4. create a new logfile, same name as the old one, where you want it
> 5. switch logs until the new one is current
> 6. drop the temporary log file
>
> >--- aheda_at_cdotd.ernet.in wrote:
> > >
> > > I am facin certain problems while tuning the
> > > performance of oracle .It
> > > would be of great help if somebody can give
> > > suggestions over:
> > > 1).how can we change the redolog files path on a
> > > running system.
> > > 2). If we are havinfg two datafiles under one
> > > tablespace how can we move
> > > one move certain tables to one file completely
> > >
> > >
> > >
Received on Mon Jul 10 2000 - 10:13:01 CDT