OraFAQ Forum: SQL & PL/SQL » How to find tablespace name ?

Home » SQL & PL/SQL » SQL & PL/SQL » How to find tablespace name ?

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

How to find tablespace name ? [message #33433]

Tue, 12 October 2004 05:09

Bob1200
Messages: 11
Registered: October 2001

Junior Member

How do I find tablespace name from a table name? its in Oracle 8i.

�

Report message to a moderator

Re: How to find tablespace name ? [message #33434 is a reply to message #33433]

Tue, 12 October 2004 06:00

Bhavin Mehta
Messages: 18
Registered: October 2003

Junior Member

Hi there,

You can execute,

select tablespace_name
from all_tables
where table_name = &your_table_name

Regards.
Keyur

Report message to a moderator

Re: How to find tablespace name ? [message #33501 is a reply to message #33433]

Fri, 15 October 2004 01:24

Elavarasu Perumal
Messages: 2
Registered: October 2004

Junior Member

SQL> select tablespace_name from dba_tablespaces
2
SQL> /

TABLESPACE_NAME
------------------------------
SYSTEM
AVPRBS01
AVP_TEMP
AVP_DEAL_DAT
AVP_DEAL_IDX
AVP_WORK_DAT

Report message to a moderator

Re: How to find tablespace name ? [message #34800 is a reply to message #33434]

Mon, 03 January 2005 22:56

manishkumarsinha
Messages: 1
Registered: January 2005

Junior Member

Hi there,

Through this u can know all the tablespaces of database

select * from dba_tablespaces

Regards
Manish

Report message to a moderator

Previous Topic:	re: Multiple insert statements in pl/sql procedure
Next Topic:	PL/PDF project

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 20 01:18:22 CDT 2025