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: 25574
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: 65144
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: 65144
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: 65144
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: SGA MAX SIGE
Next Topic: ORA-20000: index "SYS"."WRH$_ACTIVE_SESS_HIST_PK"
Goto Forum:
  


Current Time: Mon Aug 21 01:43:26 CDT 2017

Total time taken to generate the page: 0.09465 seconds