Re: Any dangers when changing pctfree etc on live system ?

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Wed, 01 Nov 2000 16:21:55 -0500
Message-Id: <10667.120871@fatcity.com>

Steve,
When you change the pctfree on a table it only effects the new blocks of = data added to the table. The old blocks still maintain the old setting. To = eliminate the old block setting you should save the data and recreate the = table with the new settings and reload the data. ROR =AA=BF=AA
>>> Steve.Parker_at_lis.co.uk 11/01/00 12:46PM >>>
List,

A fellow DBA has asked if it is completely safe to change the pctfree values etc on a live
system.

I thought there shouldn't be any isues as no data is actually being = changed
only
the default storage parameters that will be used when new blocks are created.

Any experience, gotchas etc appreciated

Steve Parker
Technical Consultant
LIS

Logistics & Internet Systems Ltd.
United Kingdom
E Mail: steve.parker_at_lis.co.uk=20

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author:=20
INET: Steve.Parker_at_lis.co.uk=20

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Wed Nov 01 2000 - 15:21:55 CST