RE: Reconfiguring datafiles

Dennis and others,

Thanks for your respond, it is very useful for me.

Kind Rgrds,

Sony

> -----Original Message-----
> From: DENNIS WILLIAMS [SMTP:DWILLIAMS_at_LIFETOUCH.COM]
> Sent: Tuesday, February 18, 2003 9:24 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Reconfiguring datafiles
>
> Sony
> 1. You can expand a datafile if it is full, assuming your storage
> device
> still has space and you are not near your operating system limit.
> 2. You can move a datafile to another storage device if you need to.
> 3. If you need to move data out of a datafile, the easiest way to do
> this
> is to create a second tablespace, which will have its own datafile(s).
> Then
> move the objects stored in the first tablespace into the second
> tablespace.
> 4. Within a tablespace that has more than one datafile, you can't tell
> Oracle where to put the data, or to move data from one datafile to
> another.
> I hope one of the above responds to your question. :-)
>
> Dennis Williams
> DBA, 40%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
> -----Original Message-----
> Sent: Tuesday, February 18, 2003 1:24 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear Listers,
>
> Would someone on this list help me to solve these problems,
> 1. I've three datafiles x1 and x2
> 2. If datafile x1 is full, I want it is automaticaly move to datafile x2
> including all data in datafile x1.
> 3. If it is possible how to do it.
>
> Many thanks for respons and all comments would be appreciated.
>
> Kind rgrds,
>
> Sony
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Sony kristanto
> INET: Sony_at_polyfincanggih.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.COM
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Sony kristanto
  INET: Sony_at_polyfincanggih.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).