sqlplus执行@sql.sql的错误

最新推荐文章于 2024-12-30 07:58:04 发布

最新推荐文章于 2024-12-30 07:58:04 发布 · 385 阅读

文章标签：

#SQL #REST #Unix

oracle 专栏收录该内容

7 篇文章

订阅专栏

本文解决了一个在尝试执行SQL脚本时遇到的SP2-0734错误，该错误提示未知命令并忽略剩余行。文章详细解释了如何通过正确的启动方式和键盘映射设置来避免这一问题。

今天给数据库执行@spcreate.sql老是出
SP2-0734:unknown command beginning "spcreate.s..." - rest of line ignored.
郁闷坏了。经过一番折腾原来是
solution Description:
=====================
You need to enter a valid SQL*Plus command.
In this case, you cannot start svrmgrl from within SQL*Plus,
you have to start svrmgrl from the command prompt.
This error will also occur when trying to execute a
the @ symbol is mapped to the key 'Kill' from the user's keyboard.
The way to find out the current keyboard mapping in a unix environment is using the command 'stty -a'.
The way to correct problem is to map 'Kill' to some other keyboard symbol.
The command example would be 'stty kill ^U'.
Having remapped the key you would then log into SQL*Plus and execute script.
-------------------------------纪念一下
如果出现空行报错的话记得执行:
SET SQLBLANKLINES ON