-- 查用户
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;
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;