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

Home -> Community -> Usenet -> c.d.o.misc -> Sys.dba_tables.compression missing in 9.2.0.8 database - why?

Sys.dba_tables.compression missing in 9.2.0.8 database - why?

From: Tarby777 <nick_williamson_at_mentorg.com>
Date: 9 May 2007 01:40:23 -0700
Message-ID: <1178700023.056978.173590@q75g2000hsh.googlegroups.com> 





Hi all,



Why would one 9.2.0.8 database have a column named "compression" in
SYS.DBA_TABLES and another one not? That's the situation I have... I'm
trying to work with a colleague's database and my 3rd party schema
comparison / fix utility is expecting the column to be there, and
crashing out because it isn't...



Running "desc" on my SYS.DBA_TABLES and his SYS.DBA_TABLES shows that
the views are the same apart from this one difference.



TIA



Tarby
Received on Wed May 09 2007 - 03:40:23 CDT












Original text of this message













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