oral 11g数据库操作



用户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;