Question about ORACLE

[EM1107]

I am new to oracle and I would like to know if there is a way to query the oracle database to get a list of all tables or indexes created on a table space.

thanks in advance for your reply

 

[Dagon]

select * from dba_segments where tablespace_name = 'XXX'
AND segment_type in ('INDEX', 'TABLE');

 

[LKBrwnDBA]

If you are new to Oracle, it's recommended you familiarize yourself with the manuals and their content,
you can find these fine books in the online Oracle Documentation Library.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb