-
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?
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
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 !
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|