回答：可能由于登陆失败次数超出系统最大失败验证次数限制了,只需要解锁就可以了: 试下下面操作 如何 SQL> conn /as sysdba SQL> alter user scott account unlock;
执行时提示sp2-0310,unable to open file "c:\temp\table.sql" 这个目录下确实有这个文件; 在sql*plus中直接执行@c:\temp\table.sql,没有问题; 在cmd方式下,使用sqlplus user/password@test @c:\temp\table.sql 便会提示出错; 在cmd方式,先进入sqlplus user/password@test,只有在文件所在目录执行@c:\test...
skeleton表示当前目录的skeleton.sql文件。你必须将skeleton.sql拷贝到你当前执行sqlplus的目录,查看你当前处于哪个目录:SQL> ! pwd /home/oracle SQL> 如果你的文件不是在当前目录,而你又不想拷贝文件到当前目录来,那得在执行时指定路径即可(下面假设你文件所在路径为e:\oracle\):SQL> @e:\oracle\sk...
提示:SP2-0310: 无法打开文件 "test.sql"在SQLPLUS里面使用start test.sql 报无法打开文件 sql语句也很简单,每啥问题 请问老师是什么问题呢~ Yeats_Li 2015-06-26源自:Oracle数据库开发必备利器之SQL基础 2-1 关注问题 我要回答 10943 分享 操作 收起 1 回答好帮手慕珊 2015-06-26 写绝对路径试试,比如te...
@skeleton表示当前目录的skeleton.sql文件。你必须将skeleton.sql拷贝到你当前执行sqlplus的目录,查看你当前...
C:\>set ORACLE_SID=<Database SID>ORACLE_HOME>sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 27 10:41:21 2017Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production...
The shell scripts and sql files are located in $HOME/bin. But for some reason it is not executing. I am not sure how to address this issue. can u please help. Thanks 1sqlplus / @load_data.sql$SCHEMA$PASSWD| \2tee-a >>$PROCLOG3...
2,0 SP2-0310 unable to open file Hi , We are running Oracle 8.1.7 on HP-UX B.11.00. Recently we have upgraded Oracle from 8.0.6. to 8.1.7. Almost all the shell script we use has the Sqlplus as sqlplus -s @/apps/prod/sql/xxxx.sql > /apps/prod/log/xxxx.out . ...
I am able to create a directory using SQLPLus, and I get the "Directory Created" message, but no directory actually gets created on the server. SQL> CREATE DIRECTORY datapump AS 'C:Inetpubdatafiledatapump'; Directory created. But I dont see the directory created on the server. ...
一、无法打开文件“xxx.lib” 出现这种错误一般为 ①未添加xxx.lib库文件 ②库添加后，路径不对...