Home » RDBMS Server » Server Administration » TableSpace Information (merged) (Oracle 9i/10G)
TableSpace Information (merged) [message #425824] Mon, 12 October 2009 07:10 Go to next message
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





Re: TableSpace Information (merged) [message #425845 is a reply to message #425824] Mon, 12 October 2009 08:15 Go to previous messageGo to next message
Michel Cadot
Messages: 63814
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: TableSpace Information (merged) [message #425927 is a reply to message #425845] Tue, 13 October 2009 03:03 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Thanks
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:
  


Current Time: Fri Sep 30 14:04:16 CDT 2016

Total time taken to generate the page: 0.20302 seconds