ERROR:ORA-28009: connection to sys should be as sy - [oracle10g]
1.sqlplus登陆时:例如,以sys为用户名,password为密码,sysdba为连接身份登录或连接到sql*plus,则输入用户名称:sys,口令:password,主机字符串:orcl as sysdba
Export: Release 10.1.0.2.0 - Production on 星期四 8月 6 07:42:28 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Username: sys/oracle@ora1 as sysdba full='Y'
2.dos登陆时:C:/Documents and Settings/admin>exp
Export: Release 10.1.0.2.0 - Production on 星期四 8月 6 07:42:28 2009
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Username: sys/oracle@ora1 as sysdba full='Y'
然后往下面输入就可以了
一般最好导出数据和导入数据库的用户名相同!试试