OraFAQ Forum: Server Administration » TableSpace Information (merged)

Home » RDBMS Server » Server Administration » TableSpace Information (merged) (Oracle 9i/10G)

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

TableSpace Information (merged) [message #425824]

Mon, 12 October 2009 07:10

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Hello All,

following is Simple but quit tricky....

dba_table / all_tables and sortable does not show tablespace_name if Table is Partition or if it is IOT... and i have followings questions....

1) why it does not show tablespace_name ?
2) which is the very simple way to get it tablespace_name for Partition table and IOT ?

I could to manage to get it by joining
(Just a sample query )
select
User_segment.tablespace_name
from Dba_table ,user_constraint , user_segment
Dba_table.Ttable_name = user_constraint.table_name
and user_constraint.table_name = user_segment.table_name

let me know if you have any other way..?????

Cool

Report message to a moderator

Re: TableSpace Information (merged) [message #425845 is a reply to message #425824]

Mon, 12 October 2009 08:15

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

1) Because it is meaningless in that case.
2) partition->dba_tab_partitions, iot->dba_indexes or dba_segments for both.

Regards
Michel

Report message to a moderator

Re: TableSpace Information (merged) [message #425927 is a reply to message #425845]

Tue, 13 October 2009 03:03

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

Thanks

Report message to a moderator

Previous Topic:	multiByte characters insertion/selection from oracle database problems
Next Topic:	unable to find the table details from tab table with DBA role (merged 7)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jan 12 07:47:36 CST 2025