Re: Resizing a Data File

From: Johnny Verhoeven <Johnny.Verhoeven_at_ping.be>
Date: 1997/06/12
Message-ID: <33A0BEEC.68C8@ping.be>#1/1

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. Received on Thu Jun 12 1997 - 00:00:00 CDT