When viewing the table script for a partitioned table with compressed partitions in the Schema Browser, TOAD will display the default for the table is 'NOCOMPRESS' instead of 'COMPRESS'.
The COMPRESS is not honored at the table level, but is applied at the partition level.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center