Oracle Database Discussions

Hi All,

when i was trying to find the all objects in the tablespace i found few difference . i.e,

there are 10 tables which are in "A_TABLESPACE" table space . and i found those ten records using below query.

select * from dba_tables where tablespace='A_TABLESPACE'

But when i am getting same information from dba_segments , i found only 8 tables and two tables are missing. i went and i checked the properties of those two missing tables. in that properties , the "SEGMENT_CREATED=NO".

Here my question is how to find the all objects in table space. i used below query to find the objects in the table space and i moved those objects only from one table space to another table spact.

Query:

select distinct segment_type from dba_segments where tablespace_name='A_TABLESPACE' ;

Result
---
LOBINDEX
INDEX PARTITION
TABLE SUBPARTITION
TABLE PARTITION
INDEX SUBPARTITION
TABLE
INDEX

and i moved only those objects to B_TABLESPACE. is there any other table to find out the objects in the tablespace ? if that is there please let me know.


Thanks
Sree