Home » RDBMS Server » Server Administration » One of my tablespaces is not listed in dba_free_spaces (Oracle 9i EE 9.2.0.4.0 on RL-3)
One of my tablespaces is not listed in dba_free_spaces [message #309131] Wed, 26 March 2008 09:16 Go to next message
kiran.satyan
Messages: 25
Registered: March 2008
Location: Bangalore
Junior Member
Hi All,

One of my tablespaces is not listed in dba_free_spaces.
Tablespace has objects and its not offline.
What may be the reason for that??

Reading The Fine Manuals....Smile

Thanks and Regards

Kiran

Report message to a moderator

Re: One of my tablespaces is not listed in dba_free_spaces [message #309133 is a reply to message #309131] Wed, 26 March 2008 09:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
most likely that tablespace holds either UNDO or TEMPORARY segments.

Report message to a moderator

Re: One of my tablespaces is not listed in dba_free_spaces [message #309135 is a reply to message #309131] Wed, 26 March 2008 09:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Maybe because it has no more free space. Logical, doesn't it?

Regards
Michel

Report message to a moderator

Re: One of my tablespaces is not listed in dba_free_spaces [message #309136 is a reply to message #309131] Wed, 26 March 2008 09:37 Go to previous messageGo to next message
kiran.satyan
Messages: 25
Registered: March 2008
Location: Bangalore
Junior Member
Sorry all...,

I think, if there is no free space in the tablespace and it is not extending automatically, oracle is not going to show the details in dba_free_space.

Is that right???

Thanks and Regards

Kiran

Report message to a moderator

Re: One of my tablespaces is not listed in dba_free_spaces [message #309138 is a reply to message #309136] Wed, 26 March 2008 09:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Is this not what I said?

Regards
Michel

Report message to a moderator

Re: One of my tablespaces is not listed in dba_free_spaces [message #309141 is a reply to message #309138] Wed, 26 March 2008 09:48 Go to previous messageGo to next message
kiran.satyan
Messages: 25
Registered: March 2008
Location: Bangalore
Junior Member
Ok,
Before getting those replies , I've posted my second message..
I was thinking about that..!!

If my undo tablespace is full ..does oracle use one of my other tablespaces??


rgds

Kiran

Report message to a moderator

Re: One of my tablespaces is not listed in dba_free_spaces [message #309143 is a reply to message #309141] Wed, 26 March 2008 10:04 Go to previous message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No.
UNDO is special.
And generally speaking, an object belongs to one tablespace at most.

Regards
Michel

Report message to a moderator

Previous Topic: Is it safe to query X$ ?
Next Topic: Schedular not working
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 02 03:40:05 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.