SP2-0642: SQL*Plus Internal Error State 1075, Context 1:5:4294967295 (Doc ID 1185294.1)

Last updated on JULY 14, 2017

Applies to:

SQL*Plus - Version 11.1.0.6 to 11.1.0.7 [Release 11.1]
Information in this document applies to any platform.

Symptoms

When execute a query returning a large set of data with trace to gather statistics, it fails with error:
SP2-0642: SQL*Plus internal error state 1075, context 1:5:4294967295
Unsafe to proceed

Listed below are the complete details:

10:55:55 SQL> set autotrace traceonly
10:56:05 SQL> select * from  "Very_large_table"
10:56:15 2 /

21610958 rows selected.

Elapsed: 00:06:09.68

Execution Plan
----------------------------------------------------------
Plan hash value: 172085227
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Tim
e |
| 0 | SELECT STATEMENT | | 21M| 3457M| 154K (1)| 00:
30:59 |
| 1 | TABLE ACCESS FULL| Very_large_table | 21M| 3457M| 154K (1)| 00:
30:59 |
.......
......
Statistics
----------------------------------------------------------
1 recursive calls
0 db block gets
1975553 consistent gets
568174 physical reads
0 redo size
SP2-0642: SQL*Plus internal error state 1075, context 1:5:4294967295
Unsafe to proceed

15848550 bytes received via SQL*Net from client
1440732 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
21610958 rows processed

Changes

There is no change in environment.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms