Home » RDBMS Server » Server Administration » When does my tablesspace gets full
When does my tablesspace gets full [message #58387] Fri, 22 August 2003 03:57 Go to next message
yram
Messages: 75
Registered: February 2001
Member
Hi

Why and when does my tablespace gets full even though i have the size as 1 gb ?

regards
yram

Report message to a moderator

Re: When does my tablesspace gets full [message #58389 is a reply to message #58387] Fri, 22 August 2003 06:17 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
 
1. You may have some data, worth of 1gb.
2. You may have data and indexes in the same tablespace.
3. if the tablesapce is temp or rbs or undotbs ,
   you have to look into the design.

Report message to a moderator

Re: When does my tablesspace gets full [message #58410 is a reply to message #58387] Mon, 25 August 2003 05:04 Go to previous message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
Maybe you have a temp tablespace as permanent.

Also check which tablespaces are increasing the most.

Check that.

Report message to a moderator

Previous Topic: ora-12638
Next Topic: archivelog ot noarchivelog
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 13:34:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.