Oracle常用命令1

一. 安装是用户管理：
sqlplus /nolog;
connect /as sysdba;
alter user sys identified by change_on_install;

alter user system identified by manager;

alter user scott identified by tiger;
（默认scott锁定）(scott用户中有emp dept等表)
alter user scott account unlock;

二.  Oracle常用命令：

show user;（查看当前用户）
connect sys/change_on_install as sysdba;（切换sys用户）
或connect sys/change_on_install as sysoper;（切换sys用户 ）
connect system/manager;
connect scott/tiger;

Oracle常用命令1

原文：http://www.cnblogs.com/raywwen/p/3560566.html