Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: In Oracle 9i which data dictionary view I need to use to find out the table is compress

Re: In Oracle 9i which data dictionary view I need to use to find out the table is compress

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 29 Sep 2006 15:57:09 -0700
Message-ID: <1159570629.629335.290960@b28g2000cwb.googlegroups.com> 






lakiprabha_at_gmail.com wrote:


> In Oracle 9i which data dictionary view/table I need to query to find

> out the table is compress/nocompress.

>

> In Oracle 10g the following query is working fine but when I use same

> query in Oracle 9i its not working

>

> SELECT TABLE_NAME, COMPRESSION FROM USER_TABLES ;



Works for me in my 9.2 ( 9208 ) database.  It is a 9.2 feature.



Do you have some old 9.1 database that hasn't been upgraded?  Then the
feature is not yet present.
Received on Fri Sep 29 2006 - 17:57:09 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US