Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to determine if a table is compressed in 9.2?

371321Nov 15 2002

Hello,

I want to know how to determine if a table is compressed or not in Oracle 9.2. For partitioned tables there is a COMPRESSION column in DBA_TAB_PARTITIONS and DBA_TAB_SUBPARTITIONS, but I have not found any column in the data dictionary that will tell me this for regular, non-partitioned tables. Any ideas?

Thanks,
Chris Durand

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 30 2002

Added on Nov 15 2002

#general-database-discussions

3 comments

295 views