Home » Server Options » Replication » ORA-00997 (Oracle Database 10G)
ORA-00997 [message #454426] Wed, 05 May 2010 08:52 Go to next message
monandra
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: 59143
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Create the view on the remote site and query the remote view.

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


Current Time: Fri Sep 19 17:26:53 CDT 2014

Total time taken to generate the page: 0.12401 seconds