SELECT * FROM DBA_TABLESPACES; --查看表空间
DESC DBA_TABLESPACES; --查看表空间结构
SELECT * FROM DBA_DATA_FILES; --查看数据的表空间数据字典,表的存储位置
SELECT * FROM DBA_TEMP_FILES; --查看数据的临时表空间数据字典,表的存储位置
SELECT * FROM DBA_TS_QUOTAS;
SELECT *
FROM ROLE_SYS_PRIVS --查看角色字典
WHERE ROLE IN('CONNECT','RESOURCE')
ORDER BY ROLE;