ORA-00997 [message #454426] |
Wed, 05 May 2010 08:52 |
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 |
|
Michel Cadot
Messages: 68665 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
|
|
|