OraFAQ Forum: Performance Tuning » when database is full

Home » RDBMS Server » Performance Tuning » when database is full

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

when database is full [message #65832]

Thu, 06 January 2005 18:48

Ravikumar.V
Messages: 26
Registered: July 2004

Junior Member

when database is full how to exten the size of data base

Report message to a moderator

Re: when database is full [message #65833 is a reply to message #65832]

Thu, 06 January 2005 20:36

Frank Naude
Messages: 4596
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

Report message to a moderator

Previous Topic:	Explain the explain plan
Next Topic:	Sorting Results

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 23:44:18 CDT 2025