ORA-00997 [message #454426] |
Wed, 05 May 2010 08:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68658 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
|
|
|