ChinaUnix.net
相关文章推荐:

用sqlplus 进行hanganalyze

輸入sqlplus sys/abc@ORCL as sysdba @d:\coldbackup.ext 之後出現: Usage: sqlplus [ [

by frankyx7 - Oracle - 2008-01-12 08:51:13 阅读(3179) 回复(2)

相关讨论

$ dbstart Can't find init file for Database "dec9i". Database "dec9i" NOT started. $sqlplus /nolog SQL*Plus: Release 9.2.0.1.0 - Production on Wed Apr 21 19:36:51 2004 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. SQL>; connect / as sysdba Connected to an idle instance. SQL>; startup ORACLE instance started. Total System Global Area 98012640 bytes Fixed Size ...

by campoeagle - Oracle - 2004-04-21 19:37:49 阅读(471) 回复(0)

shell如何与sqlplus进行交互 ,请高手指教

by xiaoyuezi - Shell - 2007-12-20 17:10:23 阅读(1382) 回复(4)

客户端linux,NLS_LANG=AMERICAN 服务器端linux,NLS_LANGUAGE=AMERICAN,中文字段的类型是VARCHAR2 我netterm telnet 上去,然后sqlplus的。 奇怪的是,在windows客户端的ORACLE Enterprice Management Consle里查看数据可以看到中文,且可以按中文字段查询,而sqlplus却不行 oracle 9i

by lanying_wzw - Oracle - 2006-06-19 09:53:10 阅读(1290) 回复(1)

AS4,ORACLE 9204 已经完成建库。sqlplus登陆时出现以下状况 [quote]# su - oracle -c 'sqlplus samper/developer@koalsamp' .bash_profile executed SQL*Plus: Release 9.2.0.4.0 - Production on 星期四 3月 30 18:16:20 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ERROR: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor Enter user-name: samper...

by littledick - Oracle - 2009-02-19 15:14:24 阅读(5556) 回复(9)

exec.. 后面不记得了!!!! 谢谢!

by silvering - Oracle - 2005-07-08 12:20:02 阅读(859) 回复(2)

遇到了个比较有意思的问题, oracle9i 中sqlplus 的spool命令不支持双引号, 而在10g中却能支持, 所以在9i上就不能带空格的路径名了, 比如下面的得这段代码就不能了。 printf "%s\n" "set heading off" >;>; datafile.sql printf "%s\n" "set echo off" >;>; datafile.sql printf "%s\n" "set pages 0" >;>; datafile.sql printf "%s\n" "set feedback off" >;>; datafile.sql printf "%s\n" "set newpage none" >;>; dataf...

by stonbing - Oracle - 2005-06-15 21:56:12 阅读(1070) 回复(4)

一段简单shell script: if [ 1 -ne 0 ]; then ${ORACLE_HOME}/bin/sqlplus pmexp/pmexp <

by kennen917 - Shell - 2004-12-09 09:46:13 阅读(1133) 回复(3)

oracle ~$ sqlplus SQL*Plus: Release 9.2.0.1.0 - Production on Wed Nov 26 22:17:45 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-07217: sltln: environment variable cannot be evaluated. 请指教。谢谢。

by zhouyong488 - Solaris - 2003-11-26 23:36:54 阅读(589) 回复(1)

原来别人在unix上装了一个oracle8i,了一段时间。现在我想通过sqlplus查询一下里面都有哪些库,库里都有哪些表。怎嘛办呀? 有没有系统记录的一些参数表可以查呀,就像dba_users表似的。

by famous - Oracle - 2003-10-25 14:43:20 阅读(675) 回复(4)

oracle9i中如何使sqlplus进行远程连接呢? 我试了好多网上的方法,但是全都失败了 下面的是一个网上说的方法,但是还是失败了…… SQL> conn immspublish/123456@//127.0.0.1:1521/ora92; SP2-0306: 无效选项。 法: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] 其中 : : = [/][@] | / SQL> SQL>

by art_codes - Oracle - 2009-07-05 00:16:42 阅读(1224) 回复(5)