Re: Resizing existing database?

From: Randy <rmramos.gbs_at_worldnet.att.net>
Date: 1996/08/23
Message-ID: <4vj91p$6lq_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1


Your abilities to "EXTEND" the database are dependent on what limitations you have exceeded.

  1. You have reached the MAXDATAFILES parameter of the database.
    • increase this setting.
  2. If you have run out of space in a tablespace.
    • add another datafile to the tablespace.
    • add another tablespace.

In the docs look ata CREATE TABLESPACE and ALTER TABLESPACE add DATAFILE.

There are some other issues, These are the most common.

Hope this helps
R2
Independent Oracle Consultant Received on Fri Aug 23 1996 - 00:00:00 CEST

Original text of this message