Re: Help, delete a data file

From: Sherwin Anthony Sequeira <sherwin_at_sequeira.powernet.co.uk>
Date: 1997/07/06
Message-ID: <d5qnp5.3ll.ln@sequeira.powernet.co.uk>#1/1

In article <5p9d15$2e9o_at_elmo.cadvision.com>,

        beatonb_at_cadvision.com (Bill Beaton) writes:

> In article <33B73062.4B9_at_us.oracle.com>,
> 	"Srini(vas) Kumar Rayapeddi" <srkumar_at_us.oracle.com> writes:

>>Dave Marcus wrote:
>>
>>If its above V7.x
>>try resizing the datafile to minimum. Say 1M, if it works good.
>>Resize does not work if there is some data.
>>
>>Now you can reclaim the space avoiding problems
>>

> Do NOT ... I repeat, do NOT try this before Release 7.3.2.  There is a
> bug in Oracle's updating of the data file headers that will prevent you
> from recreating the instance using a control file IF you have resized
> a data file downwards.  This bug does not hit when you increase a datafile's
> size.

The same bug occurs with 7.3.2.3 on HP-UX 10.20 too.

> Bill Beaton
> --

Tony

-- 
S. A. Sequeira tony_at_sequeira.powernet.co.uk

Received on Sun Jul 06 1997 - 00:00:00 CDT