切换oracle用户,登录管理员账户
su - oracle
sqlplus / as sysdba
查看数据文件路径
select name from v$datafile;
查看表空间信息
select * from dba_tablespaces;
创建表空间
create tablespace clearshare_index logging datafile '/u01/app/oracle/product/19.3.0/db_1/DATA/KODE/clearshare_index01.dbf' size 100M
autoextend on next 1M maxsize unlimited extent management local;
create tablespace clearshare_data logging datafile '/u01/app/oracle/product/19.3.0/db_1/DATA/KODE/clearshare_data01.dbf' size 100M
autoextend on next 1M maxsize unlimited extent management local;
创建用户
create user clearshare identified by oracle default tablespace clearshare_data temporary tablespace TEMP profile DEFAULT;
删除用户:drop user clearshare 级联删除 drop user clearshare cascade;
赋予权限
grant connect,resource to clearshare;
grant unlimited tablespace to clearshare;
grant restricted session to clearshare;
grant exp_full_database to clearshare;
grant imp_full_database to clearshare;