| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Data file size growing causing high disk space.
David - You will inform Oracle of the new location. Here is the sequence:
SELECT FILE_NAME FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'XXXX';
ALTER TABLESPACE XXXX OFFILNE;
move the data files
ALTER TABLESPACE XXXX RENAME DATAFILE 'old location' TO 'new location';
for each datafile in the tablespace
ALTER TABLESPACE XXXX ONLINE;
Your users will be unable to access the data in that tablespace while you
have it offline.
That will work for "normal" data files. You must use a different technique
for the system tablespace, for example. And please learn more about being an
Oracle DBA or your next discussion with us may be how to recover a database
when you didn't do proper backups. I don't like those conversations.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com <mailto:dwilliams_at_lifetouch.com>
-----Original Message-----
Sent: Monday, September 23, 2002 3:14 PM
To: Multiple recipients of list ORACLE-L
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).
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).
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).
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:40:59 CDT
 |
 |