用户sys as sysdba 服务多的话还可以更改为
sys@orcl as sysdba 链接
解锁用户ALTER USER scott ACCOUNT UNLOCK;
登录scott用户 口令为tiger
检查 show user
SELECT * FROM DEPT;
修改'New York'->'QCS'
UPDATE DEPE
SET LOC='QCS'
WHERE DEPTNO=10;
在sql中你需要换用户 就用conn +[ ]
链接型用户 conn sys as sysdba
查日志文件
select group#,first_change#,next_change#,status
from v$log;
切换日志文件
alter system switch logfile;