连接到本地数据库
connect sys/localhost as sysdba
查看dba数据字典数
desc dba_users
查看Oracle数据库下的用户
select username from dba_user;
启用用户
alter user username account unlock
启用scott用户的语句
alter user scott account unlock
用scott 用户登录
connect scott/tiger
连接到本地数据库
connect sys/localhost as sysdba
查看dba数据字典数
desc dba_users
查看Oracle数据库下的用户
select username from dba_user;
启用用户
alter user username account unlock
启用scott用户的语句
alter user scott account unlock
用scott 用户登录
connect scott/tiger