PLSQL in executing queries a larger table when an error is as follows:


But in the query is executed on the server, there is no error


Most the reason of Internet, the system table space is insufficient, but does not have this problem here,


Our great god for help, has been plagued 2 days,,

CodePudding user response:

In PLSQL, you all the records, see if there are any abnormalities,

CodePudding user response:

reference 1st floor wmxcn2000 response:

in PLSQL, you put all the records, see if there are any abnormalities,

Thank you moderator reply, all the tables, in addition to the table to other tables are no problem, can direct the query, but this table query error,

CodePudding user response:

Look at the alter in log log and trace

CodePudding user response:

You query the remote table

CodePudding user response:

Ctas a look, and see if I can success;

May have a bad block,