在用scott用户导出dmp文件后,用sys用户执行IMP语句出现ORA-28009 connection to sys should be as sysdba or sysoper错误
来源:互联网 发布:java中级招聘 编辑:程序博客网 时间:2024/05/21 19:26
导入语句为imp sys/sakura file=a.dmp,结果出现ORA-28009 connection to sys should be as sysdba or sysoper错误
解决方法是:
(1)设置参数O7_DICTIONARY_ACCESSIBILITY=TRUE
这个参数在9i以前默认为True,但从9i开始是false,若不改此参数,直接用connect sys/password@connectstring,则报以下错:
ORA-28009: connection to sys should be as sysdba or sysoper
所以用imp sys/password@connectstring file=......不能import入数据时,
更改后就可以用sys身份imp入在8i下以sys export出的数据了。
- 在用scott用户导出dmp文件后,用sys用户执行IMP语句出现ORA-28009 connection to sys should be as sysdba or sysoper错误
- sys用户登录出现错误提示 ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER
- ORACLE数据库使用SYS用户登录出现:ORA-28009:connection as SYS should be as SYSDBA or SYSOPER报错处理办法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- 【ORACLE】用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法
- ORA-28009 Connection to SYS should be as sysdba or sysoper
- connection to sys should be as sysdba or sysoper 解决办法
- ORACLE用SYS登录报ORA-28009:connection as SYS should be as SYSDBA OR SYSOPER解决方法和修改sys密码
- ORA-28009:Connection as SYS should be as sysdba or sysoper
- linux2.6内核,如何指定内核启动参数
- C++开发python扩展模块:ImportError: dynamic module does not define init function (initRabbit)解决办法
- string 最佳实践(C#版) (IS2120@CSDN)
- Flex文本框自动提示(AutoSuggest)、自动完成(AutoComplete)
- 毕业设计管理系统小结
- 在用scott用户导出dmp文件后,用sys用户执行IMP语句出现ORA-28009 connection to sys should be as sysdba or sysoper错误
- WPF:属性触发器
- 函数返回值类型问题
- oracle使用小结
- 初识svn
- IC前端设计絮论
- Android使用命令行打APK包
- ArcMap编辑SQLServer的ArcSDE图层提示:The Create Feature task could not be completed.
- 利用OpenCV求取圖像的重心