Hi,

We have a range partitioned table with 400 partitions. Metadata on the partitions when queried from the DBA_TAB_PARTITIONS view from an IDE like SQL Nav. or sqlplus shows the partitions in 2 tablespaces. DDL extracted from SQL Nav. shows them being created in only one tablespace. Has anyone encountered this problem and why does this happen ?


TIA,