Re:RE: Data file size growing causing high disk space.

From: <dgoulet_at_vicr.com>
Date: Mon, 23 Sep 2002 13:08:54 -0800
Message-ID: <F001.004D7281.20020923130854@fatcity.com>

David,

From he contents of the messages in this thread I conclude that you have not had any DBA training, right?

Anyway, Yes you can move one or more of the datafiles while either the database is shutdown or the tablespace is off line. If you have the database in "archive log mode" you can:

alter tablespace <tablespace name> offline
at the Operating system prompt move the datafile from location 1 to it's new home.
alter database rename file '<file_name_at_start>' to '<file_name_at_end>'; alter database recover tablespace <tablespace_name>; alter tablespace <tablespace_name> online;

If on the other hand your database is not in "archive log mode" then you'll have to shutdown Oracle before you can do anything. as in:

shutdown immeidate
at the Operating system prompt move the datafile from location 1 to it's new home.
startup mount alter database rename file '<file_name_at_start>' to '<file_name_at_end>'; alter database open.

Dick Goulet

____________________Reply Separator____________________
Author: "Nguyen; David M" <david.m.nguyen_at_xo.com>
Date:       9/23/2002 12:13 PM

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

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

--

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

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------