Re: Resizing existing database?

From: Dick Allie <dallie_at_ionet.net>
Date: 1996/08/22
Message-ID: <321C63EE.178_at_ionet.net>#1/1


Bas Ven wrote:
>
> Hi,
>
> I would like to know if its is possible to resize an existing database?
> The current (test) database has reached its limit and we would like to
> extend it. It is either so trivial or stupid that we can't find
> anything in the docs that explains the how to. All help is appreciated.
>
> Bas
> --
> ------------------------------------------------------------------------------
> J.B. Ven | Alcatel Telecom
> Nederland b.v.
> Phone: (+31) 70 3079130 | P.O. Box 3292
> Fax: (+31) 70 3079191 | NL-2280 GG Rijswijk
> Work: mailto:ven%nlsun1_at_btmv.bel.alcatel.be | The Netherlands
> Home: mailto:basven_at_xs4all.nl |
> ------------------------------------------------------------------------------

By resizing I assume you want to add more space to your tablespaces. You do this by altering the tablespace add datafile 'filename' size.

You can also create new tablespaces to add to the database.

If you have run out of files to extend the database you are out of luck except to export the entire database, drop it, and recreate it larger then import the full export.

Hope this helps.

Dick Allie - DBA Macklanburg_Duncan Oklahoma City, OK mail to dallie_at_ionet.net Received on Thu Aug 22 1996 - 00:00:00 CEST

Original text of this message