-
Partition question !
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,
:)
-
Oracle catalog is right; SQL Nav is wrong.
Are you sure DDL is not showing a general tablespace and then a specific tablespace for just "some" of the partitions?
-
Well both sqlplus (from the Oracle catalog) and SQL Nav. show the same result for the query. The DDL extracted from SQL Nav is clear - shows only one TBS. for all the partitions !
:)