Oracle常用命令

查看所有用户

1
2
3
select * from all_users;
select * from dba_users;
select * from user_users;

查看SID

1
select * from v$instance;

查看所有表空间

1
select * from v$tablespace;

查询表空间文件所在路径

1
select * from dba_data_files;

查看用户所拥有的角色

1
2
select * from dba_role_privs;
select * from user_role_privs;

用户修改密码,Oracle给用户解锁

1
2
ALTER USER "SCOTT" IDENTIFIED BY "*******"
ALTER USER "SCOTT" ACCOUNT UNLOCK

显示当前连接用户

1
show user;


发表评论

电子邮件地址不会被公开。 必填项已用*标注