Re: Resizing a Data File

Johnny Verhoeven wrote:
>
> Dennis Flinn wrote:
> >
> > Kevin Kinney wrote:
> > >
> > > I have reached my OS file limit, I am using Oracle 7.1.6, and I need to
> > > increase the size of a datafile. What is the best way to approach this
> > > problem? Should I use export? Thanks in advance.
> >
> > I guess that while not having worked with Oracle on VMS - couldn't you
> > just alter the tablespace(s) and add additional data files?
> >
> > Dennis
>
> Oracle 7.3 allows extention of datafiles.
> Lower version require export of all TS data, delete TS and recreate a
> larger one then import the data again.
>
> Johnny Verhoeven
> Technic And Technology
> On VMS you can backup the disk (file backup not immage) and initialize
> the disk with a lager index.

Johnny -

Be wary of the resize/autoextend option... I have found it impossible to use the RECREATE CONTROLFILE statement after resizing datafiles!

-- 

Allan Seabrook
--------------------------------------------------------------------------
Tel (Cellular) : +27 11 82 800 4344
           Fax : +27 11 913 3916
        E-Mail : allan_at_icon.co.za
--------------------------------------------------------------------------