Home » RDBMS Server » Server Administration » all objects in tablespace
all objects in tablespace [message #52984] Thu, 22 August 2002 18:42 Go to next message
fani bachsin
Messages: 4
Registered: August 2002
Junior Member
hi, anyone know how to find all objects under one tablespace ? the structure like "schema, owner, tablespace, table_name", tks.

Report message to a moderator

Re: all objects in tablespace [message #52986 is a reply to message #52984] Thu, 22 August 2002 19:29 Go to previous messageGo to next message
Trifon Anguelov
Messages: 514
Registered: June 2002
Senior Member
Query the views DBA_TABLES and DBA_INDEXES. They both have TABLESPACE_NAME and OWNER column.

Hope that helps,

clio_usa
OCP - DBA

Visit our Web site

Report message to a moderator

Re: all objects in tablespace [message #52999 is a reply to message #52984] Fri, 23 August 2002 04:40 Go to previous message
Grant
Messages: 578
Registered: January 2002
Senior Member
select owner,segment_name,segment_type from dba_segments where tablespace_name='SYSTEM';

Report message to a moderator

Previous Topic: DBA help
Next Topic: Problem with table created in lower case in user_tables
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:34:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.