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: Cannot drop a column with a long data type

Re: Cannot drop a column with a long data type

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 30 Mar 2006 12:29:37 -0800
Message-ID: <1143750577.140101.9020@j33g2000cwa.googlegroups.com> 





That is because a materialized view cannot contain a Long.



>From Oracle9i Advanced Replication Release 2 (9.2) Part Number

A96567-01


>> Oracle does not support the replication of columns that use the LONG and LONG RAW datatypes. Oracle simply omits columns containing these datatypes from replicated tables. You should convert LONG datatypes to LOBs. <<




HTH -- Mark D Powell --
Received on Thu Mar 30 2006 - 14:29:37 CST












Original text of this message













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