Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data file size growing causing high disk space.

RE: Data file size growing causing high disk space.

From: Nguyen, David M <david.m.nguyen_at_xo.com>
Date: Mon, 23 Sep 2002 12:13:39 -0800
Message-ID: <F001.004D7185.20020923121339@fatcity.com>


Yes, I have autoextend turned on for some of them. If I move them to a different directory, how does oracle database recognize its new directory? Is it something I need to setup in init.ora file?

Thanks,
David

-----Original Message-----
Sent: Monday, September 23, 2002 12:13 PM To: Multiple recipients of list ORACLE-L

Sent: Monday, September 23, 2002 11:05 AM To: 'ORACLE-L_at_fatcity.com'
Cc: 'david.m.nguyen_at_xo.com'

David - Do you have autoextend turned on for any of your datafiles? It is pretty simple to relocate some of your datafiles to another disk drive if that is your question. That datafile will be unavailable to your users for a few moments while you move them. You definitely want to take care of this issue immediately.

 
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>

-----Original Message-----
Sent: Monday, September 23, 2002 11:24 AM To: Multiple recipients of list ORACLE-L

I have data files save under /export/home/oradata directory and this directory shows 100% full disk space because of the growth of these files. What should I do?

Thanks,
David
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nguyen, David M
  INET: david.m.nguyen_at_xo.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.com
--

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.com
--

Author: Nguyen, David M
  INET: david.m.nguyen_at_xo.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 Mon Sep 23 2002 - 15:13:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US