在sqlplus中执行输入sql 删除时默认需要按ctrl+backspace，在配置文件中加了stty erase ^H 后,可直接用backspace键删除， 但该内容会导致执行脚本时提示：stty: standard input: Inappropriate ioctl for device。 如果出现这种提示只需要将stty的内容删除即可。 http://www.cndba.cn/dave/article/3558

http://www.cndba.cn/dave/article/3558

http://www.cndba.cn/dave/article/3558http://www.cndba.cn/dave/article/3558

http://www.cndba.cn/dave/article/3558

http://www.cndba.cn/dave/article/3558

http://www.cndba.cn/dave/article/3558http://www.cndba.cn/dave/article/3558

http://www.cndba.cn/dave/article/3558

http://www.cndba.cn/dave/article/3558

[dave@www.cndba.cn orz]# python orz.py tsfree
stty: standard input: Inappropriate ioctl for device
+-----------------+----------------+--------+---------------+--------------+---------------+
| TABLESPACE_NAME | TOTAL_SIZE(Mb) | BLOCKS | USED_SIZE(Mb) | USED_RATE(%) | FREE_SIZE(Mb) |
+-----------------+----------------+--------+---------------+--------------+---------------+
| EXAMPLE         | 346.25         | 44320  | 310.19        | 89.59        | 36.06         |
| USERS           | 31.25          | 4000   | 4.12          | 13.18        | 27.13         |
| UNDOTBS1        | 140            | 17920  | 15.25         | 10.89        | 124.75        |
| LEI             | 10             | 1280   | 1.06          | 10.6         | 8.94          |
| SYSTEM          | 940            | 120320 | 936.06        | 99.58        | 3.94          |
| SYSAUX          | 1670           | 213760 | 1581.56       | 94.7         | 88.44         |
+-----------------+----------------+--------+---------------+--------------+---------------+

#查看stty：
[dave@www.cndba.cn orz]# grep stty  /home/oracle/.bash_profile 
stty erase ^h 

#删除stty：
[dave@www.cndba.cn orz]# sed -i '/stty/d' /home/oracle/.bash_profile

#生效参数：
[dave@www.cndba.cn orz]# source  /home/oracle/.bash_profile

#问题解决：
[dave@www.cndba.cn orz]# python orz.py tsfree
+-----------------+----------------+--------+---------------+--------------+---------------+
| TABLESPACE_NAME | TOTAL_SIZE(Mb) | BLOCKS | USED_SIZE(Mb) | USED_RATE(%) | FREE_SIZE(Mb) |
+-----------------+----------------+--------+---------------+--------------+---------------+
| EXAMPLE         | 346.25         | 44320  | 310.19        | 89.59        | 36.06         |
| USERS           | 31.25          | 4000   | 4.12          | 13.18        | 27.13         |
| UNDOTBS1        | 140            | 17920  | 15.25         | 10.89        | 124.75        |
| LEI             | 10             | 1280   | 1.06          | 10.6         | 8.94          |
| SYSTEM          | 940            | 120320 | 936.06        | 99.58        | 3.94          |
| SYSAUX          | 1670           | 213760 | 1581.56       | 94.7         | 88.44         |
+-----------------+----------------+--------+---------------+--------------+---------------+
[dave@www.cndba.cn orz]#

版权声明：本文为博主原创文章，未经博主允许不得转载。