Home » RDBMS Server » Performance Tuning » when database is full
when database is full [message #65832] Thu, 06 January 2005 18:48 Go to next message
Ravikumar.V
Messages: 26
Registered: July 2004
Junior Member
when database is full how to exten the size of data base
Re: when database is full [message #65833 is a reply to message #65832] Thu, 06 January 2005 20:36 Go to previous message
Frank Naude
Messages: 4565
Registered: April 1998
Senior Member
Hi,

Then you need to add files to the database's tablespaces, or make the existing datafiles autoextensible.

To add space to a tablespace:

ALTER TABLESPACE ... ADD DATAFILE ...

To make datafiles autoextensible:

ALTER DATABASE DATAFILE '...' AUTOEXTEND ON;

BTW: If you don't like commands, you can add space from the Enterprise Manager GUI.

Best regards.

Frank
Previous Topic: Explain the explain plan
Next Topic: Sorting Results
Goto Forum:
  


Current Time: Wed Sep 30 11:33:32 CDT 2020