Home » Server Options » Replication » illegal use of LONG datatype error message when i create materialized view
illegal use of LONG datatype error message when i create materialized view [message #357431] Wed, 05 November 2008 05:36 Go to next message
khosravi
Messages: 68
Registered: April 2006
Member
Hello to all

I want create read only materialized view replication environment two of our tables have LONG datatype when i create materialized view against on them
I recieve this error message

CREATE MATERIALIZED VIEW MDB.TOAD_PLAN_TABLE TABLESPACE aramis REFRESH FORCE WITH ROWID AS SELECT * FROM MDB.TOAD_PLAN_TABLE@arahisto

Error report:
SQL Error: ORA-00997: illegal use of LONG datatype
00997. 00000 - "illegal use of LONG datatype"

Do you know any resort solution for it?

thanks
Re: illegal use of LONG datatype error message when i create materialized view [message #357432 is a reply to message #357431] Wed, 05 November 2008 05:39 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Hello,

1/ Database Version??

Babu
Re: illegal use of LONG datatype error message when i create materialized view [message #357434 is a reply to message #357431] Wed, 05 November 2008 05:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe you should read trhe documentation when you get such an error BEFORE posting in forum.
Restrictions on the Defining Query of a Materialized View
Materialized views cannot contain columns of datatype LONG.

I let you find where it is.

Regards
Michel

Re: illegal use of LONG datatype error message when i create materialized view [message #357440 is a reply to message #357434] Wed, 05 November 2008 06:02 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hello Mr.Michale,

Sorry for that & Thanks for your update.

Quote:
Oracle does not support the replication of columns that use the LONG and LONG RAW datatypes. You should convert LONG datatypes to LOBs.

Babu

[Updated on: Wed, 05 November 2008 06:02]

Report message to a moderator

Previous Topic: Error during add new master in not quiescing mode
Next Topic: create a Materialized View without having any data in it (merged)
Goto Forum:
  


Current Time: Thu Mar 28 18:04:34 CDT 2024