Essentially a query results are as follows:
Using PLSQL developer query results are as follows:
Your screen and oracle by DNLINK access SQL server query data, first of all to dblink point, analyzed the oracle database connection
Database connection without question, the dblink also no problem, did not find the wrong place, is indeed the oracle access the SQL server database,
Because things are delayed the other, continue to the next day, through the data up sqlplus view the oracle, miraculous phenomenon occurs, unexpectedly like SQL server data
Eventually found to be up sqlplus and inconsistent data to demonstrate in PLSQL, the data showed that abnormal PLSQL, count (*) it is normal, the result set export do contrast, found that the data is still 703, test the select field alone, is still 703, select all of the fields and into more than five hundred data,
PLSQL tools problem is suspected, intends to use the oracle SQL developer look again at diagnosis problem,
Install SQL developer to see
Perform error, tip in violation of the agreement, the length of the uac is not zero,
Access to information found that this may be in violation of the agreement across types of access databases, uac security restrictions for users,
Look at the client's uac Settings, has been closed,
May be related to the server,
On to the scene to confirm the server and the special yao Linux!!!!!!
Clue is broken again!
Don't know what the problem is, there is no contact with SQL server, the transparent gateway, I don't know how to troubleshoot the next,