RE: Reconfiguring datafiles

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Tue, 18 Feb 2003 06:24:12 -0800
Message-ID: <F001.0055016B.20030218062412@fatcity.com>

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). Received on Tue Feb 18 2003 - 08:24:12 CST