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

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: 25050
Registered: January 2009
Location: SoCal
Senior Member
most likely that tablespace holds either UNDO or TEMPORARY segments.
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: 64152
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
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

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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Is this not what I said?

Regards
Michel
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

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: 64152
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
Previous Topic: Is it safe to query X$ ?
Next Topic: Schedular not working
Goto Forum:
  


Current Time: Sat Dec 10 01:31:23 CST 2016

Total time taken to generate the page: 0.21001 seconds