OraFAQ Forum: Server Administration » One of my tablespaces is not listed in dba_free

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)

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

One of my tablespaces is not listed in dba_free_spaces [message #309131]

Wed, 26 March 2008 09:16

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

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

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

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

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

Michel Cadot
Messages: 68684
Registered: March 2007
Location: Nanterre, France, http://...

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 19:36:32 CDT 2024