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

上一篇:RHEL5.6 64bit安装oracle 11gR2单节点数据库


下一篇:PL/SQL语句执行过程