Home » Server Options » Replication » ORA-00997 (Oracle Database 10G)
ORA-00997 [message #454426] Wed, 05 May 2010 08:52 Go to next message
Messages: 1
Registered: May 2010
Junior Member
I've got a dblink between two Oracle databases. There are one view that I specify a join between four remote tables.
One of the tables does have a column defined as a long raw. I do not need that column; the query doesn´t make reference to it.
However, when I specify the query, I get this error: ORA-00997; illegal use of LONG datatype.
My question is: "how can I accomplish this query, over a dblink, given that one table has a long raw that is not part of my query ?

Re: ORA-00997 [message #454433 is a reply to message #454426] Wed, 05 May 2010 09:59 Go to previous message
Michel Cadot
Messages: 68264
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create the view on the remote site and query the remote view.

Previous Topic: error creating materialized view ORA-06550 DBMSOBJGWRAPPER.GENERATE_DDL
Next Topic: Materialized view query
Goto Forum:

Current Time: Thu Aug 18 03:36:10 CDT 2022