Home » RDBMS Server » Backup & Recovery » unable to see tablespace name (oracle 9i)
unable to see tablespace name [message #519623] Mon, 15 August 2011 15:46 Go to next message
zodiacsom
Messages: 37
Registered: December 2009
Location: pune
Member
i fired query to find the tablespace_name for the table FYI below

SQL> select table_name , tablespace_name from dba_tables where
2 table_name like 'CLAIM_HEADER';

TABLE_NAME TABLESPACE_NAME
------------------------------ ------------------------------
CLAIM_HEADER


it showing missing ....
please help me to find out tablespace_name.

thanks
Re: unable to see tablespace name [message #519629 is a reply to message #519623] Mon, 15 August 2011 17:34 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Is table EXTERNAL TABLE?

[Updated on: Mon, 15 August 2011 18:16]

Report message to a moderator

Re: unable to see tablespace name [message #519636 is a reply to message #519623] Mon, 15 August 2011 23:57 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
Name of the tablespace containing the table; null for partitioned, temporary, and index-organized tables



http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_2105.htm#i1592091

sriram
Re: unable to see tablespace name [message #519641 is a reply to message #519623] Tue, 16 August 2011 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
NEVER uses tablespace_name from dba_tables, use DBA_SEGMENTS.
Putting tablespace_name in dba_tables was an error from Oracle. It has no reason to be here.

Regards
Michel
Re: unable to see tablespace name [message #519762 is a reply to message #519641] Tue, 16 August 2011 13:57 Go to previous messageGo to next message
zodiacsom
Messages: 37
Registered: December 2009
Location: pune
Member
thank you a lot Smile
Re: unable to see tablespace name [message #519763 is a reply to message #519762] Tue, 16 August 2011 14:03 Go to previous messageGo to next message
zodiacsom
Messages: 37
Registered: December 2009
Location: pune
Member
Once again i need your great help....
i am new to partion environment and i want to know what are major issue comes and how to resolve that, any helpful url please suggest.

thanks
Re: unable to see tablespace name [message #519771 is a reply to message #519763] Tue, 16 August 2011 15:10 Go to previous message
Michel Cadot
Messages: 68042
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
New question, new topic, and take care to clearly explain your problem or concern.

Regards
Michel

[Updated on: Tue, 16 August 2011 15:10]

Report message to a moderator

Previous Topic: Disaster recovery set up
Next Topic: Creating Archivelog in Network drive
Goto Forum:
  


Current Time: Tue Nov 30 15:23:19 CST 2021