Non-partition objects

Hi
1.How can we find the non-partitioned objects in tablespaces and move these to another tablespace in oracle 10g.
2.How to find partition objects which are active in tablespaces.

Thanks in advance
mkr

neither of those questions makes sense

hi davey
y does'nt make sense, iam asking how can we find non-partitioned objects in tablespace & active partitioned objects.

take dave's advice.. restructure your questions.. and most importantly know what your asking..

I'll give it a try...

You can query dba_tab_partitions and dba_ind_partitions to find out which tables and indexes are partitioned, also in which tablespace each partition is sitting.

You can query dba_tables and dba_indexes minus select distinct from dba_tab_partitions and dba_ind_partitions to find out which tables and indexes are not partitioned, also in which tablespace the non-partitioned objects are sitting.

Thanks PAVB