RE: where to alter the path of redologs

There is one more way of moving the table in the sense the next extent which is going into the tablespace can be moved into the datafile you can do one thing for this
alter table table_name
allocate extent (datafile 'path')
now this extent better be a very big one so that your table data can fit into this only one
I have done this for one of the tables.
I am not an expert but check this out with other people before doing this

>From: "Wasserman, Sara" <sjwasserman_at_pscnet.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: where to alter the path of redologs
>Date: Mon, 10 Jul 2000 08:14:10 -0800
>
>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
> > > >
> > > >
> > > >
> > > > Arvind
> > > >
> > > >
> > > >
> >
>--
>Author: Wasserman, Sara
> INET: sjwasserman_at_pscnet.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).