SQL> INSERT INTO sel_tmp_clickdata VALUES(43, 'Sam') SQL> INSERT INTO sel_tmp_clickdata VALUES(34, 'Mary') SQL> INSERT INTO sel_tmp_clickdata VALUES(32, 'Sam') SQL> INSERT INTO sel_tmp_clickdata VALUES(23, 'Mary') SQL> INSERT INTO sel_tmp_clickdata VALUES(22, 'Sam') SQL> INSERT INTO sel_tmp_clickdata VALUES(12, 'Sam') SQL> INSERT INTO sel_tmp_clickdata VALUES(11, 'Mary') SQL> INSERT INTO sel_tmp_clickdata VALUES(2, 'Sam') SQL> INSERT INTO sel_tmp_clickdata VALUES(1, 'Mary') SQL> CREATE TABLE sel_tmp_clickdata (tstamp integer, userid varchar2(15)) TNS for 64-bit Windows: Version 12.1.0.2.0 - Production SQL> Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production TNS for Linux: Version 12.2.0.1.0 - ProductionĪs both DBs differ in their version, this lead me to the following question(s): Is this a known bug in 12.2.0.2.0 (contrary to 12.2.0.1.0) or is there any advice you can give me on tracking down the problem? Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Download toad for oracle 12.1 windows 7#
Same client-PC (SQLDeveloper-Version and Windows 7 Enterprise) trying the statement on my local dev-db (suprisingly it worked there!) using sqlplus-console instead of SQLDeveloper altering the tnsnames.ora file (changing (SERVER=DEDICATED) to (SERVER=SHARED) Searching through the web lead me to trying all of the following things: There are two Query-Samples - the first one works without any hassle:Įither this query is running way too long for its content (I usually kill it after a few minutes) or it returns "No more data to read from socket" almost instantaneously.
+for+Microsoft+Windows+(32-bit).jpg "download toad for oracle 12.1")
INSERT INTO sel_tmp_clickdata VALUES(68, 'Sam') INSERT INTO sel_tmp_clickdata VALUES(63, 'Mary') INSERT INTO sel_tmp_clickdata VALUES(60, 'Sam') INSERT INTO sel_tmp_clickdata VALUES(59, 'Sam') INSERT INTO sel_tmp_clickdata VALUES(53, 'Mary') INSERT INTO sel_tmp_clickdata VALUES(48, 'Sam') INSERT INTO sel_tmp_clickdata VALUES(47, 'Sam') INSERT INTO sel_tmp_clickdata VALUES(44, 'Mary') INSERT INTO sel_tmp_clickdata VALUES(43, 'Sam')
INSERT INTO sel_tmp_clickdata VALUES(34, 'Mary') INSERT INTO sel_tmp_clickdata VALUES(32, 'Sam') INSERT INTO sel_tmp_clickdata VALUES(23, 'Mary') INSERT INTO sel_tmp_clickdata VALUES(22, 'Sam') INSERT INTO sel_tmp_clickdata VALUES(12, 'Sam') INSERT INTO sel_tmp_clickdata VALUES(11, 'Mary') INSERT INTO sel_tmp_clickdata VALUES(2, 'Sam') INSERT INTO sel_tmp_clickdata VALUES(1, 'Mary') TNS for Linux: Version 12.1.0.2.0 - ProductionĬREATE TABLE sel_tmp_clickdata (tstamp integer, userid varchar2(15)) Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production I came across an "No more data to read from socket" error while trying out a codesample from here:
0 kommentar(er)
