OraFAQ Forum: Backup & Recovery » unable to see tablespace name

Home » RDBMS Server » Backup & Recovery » unable to see tablespace name (oracle 9i)

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

unable to see tablespace name [message #519623]

Mon, 15 August 2011 15:46

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

Report message to a moderator

Re: unable to see tablespace name [message #519629 is a reply to message #519623]

Mon, 15 August 2011 17:34

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

ramoradba
Messages: 2457
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

Report message to a moderator

Re: unable to see tablespace name [message #519641 is a reply to message #519623]

Tue, 16 August 2011 01:05

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

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

Report message to a moderator

Re: unable to see tablespace name [message #519762 is a reply to message #519641]

Tue, 16 August 2011 13:57

zodiacsom
Messages: 37
Registered: December 2009
Location: pune

Member

thank you a lot Smile

Report message to a moderator

Re: unable to see tablespace name [message #519763 is a reply to message #519762]

Tue, 16 August 2011 14:03

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

Report message to a moderator

Re: unable to see tablespace name [message #519771 is a reply to message #519763]

Tue, 16 August 2011 15:10

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 02:29:08 CST 2025