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

Report message to a moderator

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: 4579
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 23:12:45 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.