RE: Reconfiguring datafiles

From: Rajesh Dayal <Rajesh_at_ohitelecom.com>
Date: Tue, 18 Feb 2003 04:38:43 -0800
Message-ID: <F001.0054FF9B.20030218043843@fatcity.com>

Good point Hmmmm ;-)

-----Original Message-----
Carmichael
Sent: Tuesday, February 18, 2003 3:44 PM To: Multiple recipients of list ORACLE-L

first, you listed only two datafiles

second, why on earth would you want to move the data? just add datafile x2 to the tablespace and let Oracle keep going

• Sony kristanto <Sony_at_polyfincanggih.com> wrote:
  > 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).
  >
  

  ---

Do you Yahoo!?
Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.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: Rajesh Dayal
  INET: Rajesh_at_ohitelecom.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 - 06:38:43 CST