oracle命令

-- 查用户
select * from dba_users;


-- 查表空间
select * from dba_tablespaces;


-- 查表空间路径
select * from dba_data_files;


-- 删除用户
drop user supervision_test cascade;


-- 创建表空间
create tablespace supervision_test datafile '/opt/oracle/oradata/orcl/supervision_test.dbf' size 50m autoextend on next 50m maxsize 1024m;


-- 创建用户
create user supervision_test identified by cpsoft default tablespace supervision_test;


-- 用户授权
grant connect,resource,dba to supervision_test;