很有可能是服务器端数据库服务是动态注册的。建议在listener.ora中静态注册数据库服务。如：SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME=gzga)(ORACLE_HOME = D:\oracle\product\10.2.0\emes)(SID_NAME = gzga)))客户端的tnsname.ora中CONNECT_DATA 节点用SERVICE_NAME替换...
SP2-0158: unknown SET option "puase"SP2-0158: unknown SET option "trimsppol"select * from nonexistent_table ERROR at line 1:ORA-00942: table or view does not exist 登录到数据库并检查 SPERRORLOG 表中的具体错误信息，“oracle中SP2-0158怎么解决 ？”SP2-0158错误有很多种，请说明清...
运行后将生成以下错误消息: SP2-0158: unknown SET option "puase" SP2-0158: unknown SET option "trimsppol" select * from nonexistent_table * ERROR at line 1: ORA-00942: table or view does not exist 您可能见过这些消息,也可能没见过,这取决于脚本的运行方式 — 在前台通过 SQL*Plus 提示符运行...
concat "." (hex 2e) SP2-0158: unknown SHOWoption"_name" SQL> 可以发现sqlplus 是11g的。虽然sqlplus 是11g的,但是连接的却是12c数据库,这是因为我在设置环境变量的时候只设置了oracle sid 和 oracle home 没有设置path。 11g的sqlplus不识别12c的命令。所以需要用下面的方式。 [oracle@oratest profile]$/...
SP2-0158: unknown SET option "garbage" garbage * ERROR at line 3: ORA-00942: table or view does not exist To view the errror log written to the default error log table, SPERRORLOG, enter: SELECT TIMESTAMP, USERNAME, SCRIPT, IDENTIFIER, STATEMENT, MESSAGE FROM SPERRORLOG; which produces...
SP2-0158:未知的SET选项"display" SQL> exit C:\>set display verbose 环境变量display没有定义 C:\>lsnrctl LSNRCTL for 32-bit Windows: Version10.2.0.1.0 - Production on 03-3月-2008 13:5 1:37 LSNRCTL> set display verbose 服务显示模式为VERBOSE ...
SP2-0158: unknown SET option “statusbar” SP2-0158: unknown SET option “statusbar” SP2-0735: unknown SET option beginning “timing” SQLPLUS command failed – not enough arguments SP2-0158: unknown SET option beginning “highlighti…” ...
1. SQL>select*fromdual;D-XSQL>edit Wrotefileafiedt.buf211*select*fromdual(这一步如果不能退出,使用ctrl+D)SQL>set_EDITOR=vi SP2-0158: unknownSEToption"_EDITOR=vi"SQL>define_editor=viSQL>ed Wrotefileafiedt.buf1*select*fromdualSQL>ed
sp2-0158: unknown set option “severout” 了吧? set serverout on 是的, 就一个字母而已. 编程大师说: 任何软件都有bug. 但, 一个如此小的bug可以让一个全球第二大的软件公司带着它走过几个版本? oracle8.15 oracle8.16 oracle8.17…难道保留错误是为了兼容性?
SP2-0158: unknown SHOW option “session” SQL> show parameter session NAME TYPE VALUE java_max_sessionspace_size integer 0 java_soft_sessionspace_limit integer 0 license_max_sessions integer 0 license_sessions_warning integer 0 session_cached_cursors integer 50 ...