OraFAQ Forum: Server Administration » What objects are using what tablespace

Home » RDBMS Server » Server Administration » What objects are using what tablespace

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

What objects are using what tablespace [message #58491]

Wed, 03 September 2003 03:29

James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)

Member

Say i've a tablespace called lob_ts. How do i find out what objects (say tables) are in it/using it.

Oracle8i on a Sun unix platform (solaris 8).

Thanks.

Report message to a moderator

Re: What objects are using what tablespace [message #58496 is a reply to message #58491]

Wed, 03 September 2003 06:41

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

--
-- user tables and tablespaces
--
mag@mutation_mutation > select tablespace_name,table_name from user_tables;

TABLESPACE_NAME                TABLE_NAME
------------------------------ ------------------------------
SYSTEM                         BONUS
SYSTEM                         DEPT
SYSTEM                         EMP
SYSTEM                         SALGRADE

Report message to a moderator

Re: What objects are using what tablespace [message #58499 is a reply to message #58496]

Wed, 03 September 2003 08:06

James Briar
Messages: 72
Registered: January 2002
Location: Morden (South London)

Member

Thanks very much again Mahesh.

Report message to a moderator

Previous Topic:	Ora-604 error in 9i
Next Topic:	clustered and non-clustered indexes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:38:16 CDT 2024