数据库操作:
1. 查看数据文件
select name from v$datafile;
2. 查看表空间
select name from v$tablespace;
3. 查看系统权限
select * from system_privilege_map;
4. 查看角色具有哪些权限
RESOURCE角色: select * from dba_sys_privs where grantee='RESOURCE';
查看所有角色
select * from dba_roles;
5. 创建表空间
create tablespace 表空间名 datafile 文件名 size 大小;
例如create tablespace newspace datafile '/xxxx' size 3000m;
创建动态增长表空间
create tablespace 表空间名 datafile 文件名 size 大小 autoextend on next 大小 maxsize 大小
例如 create tablespace newspace datafile '/xxxx' size 5000m autoextend on next 500m maxsize 18000m;
查看所有表空间大小
select tablespace_name, sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;
查看已使用的表空间大小
select tablespace_name, sum(bytes)/1024/1024 from dba_free_space group by tablespace_name;
查看表空间的详细信息
select * from sys.dba_tablespaces;
6. 创建用户
create user 用户名 identified by 密码 default tablespace 表空间
例如create user test identified by test123 default tablespace newspace;
grant connect, resource to test;
7. 查看所有用户
select * from dba_users;
select * from all_users;
select * from user_users;
8. 查看用户对象权限
select * from dba_tab_privs;
select * from all_tab_privs;
select * from user_tab_privs;
系统权限
select * from dba_sys_privs;
select * from user_sys_privs;
9. 查看用户拥有的角色
select * from dba_role_privs;
select * from user_role_privs;